BIAM 530 Week 8 Final Exam Questions DeVry

Description

BIAM 530 Week 8 Final Exam Questions DeVry

Question 15 pts

(TCO 1) Which characteristic best describes an online transaction processing (OLTP) database?

	Stores data optimized for decision support
	Supports a company’s day-to-day operations

 

	Focuses primarily on historical data and business metrics
	Combines data from operational databases and external sources

 

Question 25 pts

(TCO 1) An object-orientated data model

	is structured as an upside-down tree.
	was introduced by E. F. Codd in 1970.

 

	represents data, relationships, and operations in a single structure.
	uses tables composed of intersecting rows and columns.

 

Question 35 pts

(TCO 2) Which of the following activities is carried out in the Planning phase of the systems development life cycle (SDLC)?

	Logical system design
	Feasibility study

 

	Detailed system specification
	Coding, testing, and debugging

 

Question 45 pts

(TCO 2) In which phase of the database life cycle (DBLC) model is the DBMS software selected?

	Database design
	Database initial study

 

	Implementation and loading
	Testing and evaluation

 

Question 55 pts

(TCO 4) What will be displayed when the following SQL statement is executed?
SELECT * FROM Employee:

	All columns in only the first row of the Employee table
	Only the first column in all rows of the Employee table

 

	All rows and columns of the Employee table
	The number of rows in the Employee table

 

Question 65 pts

(TCO 4) Because in SQL, you command what is to be done but not how, SQL is considered a _____ language.

	procedural
	portable

 

	nonprocedural
	standardized

 

Question 75 pts

(TCO 5) Aggregate functions are used to

	list only unique values.
	add primary and foreign key designations.

 

	add a column to a table.
	summarize data across multiple rows.

 

Question 85 pts

(TCO 5) INSERT INTO is used to

	update an existing record.
	change the structure of a table.

 

	add a new record to a table.
	sort information from a table.

 

Question 95 pts

(TCO 3) Cardinality is

	the minimum and maximum number of instances associated with one instance of a related entity.
	the classification of a relationship as one-to-one, one-to-many, or many-to-many.

 

	the strength of the relationship between two entities.
	the number of attributes of an entity.

 

Question 105 pts

(TCO 3) For practical purposes, the highest normal form needed for most database designs is

	first normal form.
	second normal form.

 

	third normal form.
	tenth normal form.

 

 

Question 11

(TCOs 1, 3) Describe the principles and key features of the relational data model.

 

Question 12

(TCO 6) Address each of the following:
(a) How does a data warehouse differ from an operational database?
(b) How does a data mart compare to a data warehouse?
(c) How do data warehouses and data marts contribute to business intelligence?

 

Question 13

(TCOs 7, 9) Address each of the following:
(a) Describe a distributed database management system (DDBMS).
(b) For a business with multiple geographic locations, discuss the advantages and disadvantages of using a distributed DBMS compared to a traditional centralized DBMS.
(c) Describe how the Hadoop distributed file system (HDFS) supports big data analysis.

 

Questino 14

(TCO 8) Address each of the following:
(a) Describe at least three potential threats to an organization’s data assets.
(b) Suggest appropriate countermeasures that can be taken to mitigate these threats.
(c) Discuss the role of a business intelligence professional in protecting the organization’s data assets.

 

Question 15

(TCO 10) Address each of the following:

(a) Suggest at least three key performance indicators (KPIs) that might be used for a retail store.

(b) Discuss how these KPIs could be measured and reported to managers.

(c) Discuss the role of business intelligence in developing, measuring, and monitoring these KPIs.

 

Question 16

(TCO 2) Address each of the following:
(a) Describe the major activities performed during the Database Initial Study phase of the database life cycle (DBLC).
(b) Discuss how the DBLC activities in this phase align with other activities in the software development life cycle (SDLC).
(c) Explain how the activities in the Database Initial Study phase contribute to the next phase of the next DBLC phase—the Database Design.

 

Question 17

(TCOs 4, 5) Address each of the following:
(a) Select and describe one of the common SQL data types.
(b) Provide at least three specific examples of attributes (columns) in a database that might use this data type.
(c) Discuss how, as a database designer, you would make the decision to use this data type versus an alternative type for a particular column.

 

Question 18

(TCOs 4, 5) Address each of the following:
(a) Explain what happens in a relational join operation.
(b) What is the difference between an inner join and an outer join?
(c) Give an example of a SQL SELECT statement involving a join.

 

Course Tutor helps in providing the best essay writing service. If you need 100% original papers for BIAM 530 Week 8 Final Exam Questions DeVry, then contact us through call or live chat.

BIAM 530 Week 8 Final Exam Questions DeVry

ACCT 553 DeVry, BIAM 500 DeVry, CIS 500 STR, CIS 558 STR, ENG 105 GCU, FIN 390 DeVry, FIN 504 GCU, HCA 545 GCU, HCA 699 GCU, HLT 306 GCU, HLT 362 GCU, HLT 555 GCU, HLT 610 GCU, HLT 665 GCU, HOSP 594 DeVry, HRM 600 DeVry, MAT 144 GCU, MGMT 600, MGT 599 STR, MGT 655 GCU, MKT 373 GCU, PSY 362 GCU, PSY 565 GCU, PSY 575 GCU, PSY 665 GCU, SOC 102 GCU, SOC 320 GCU, SOC 372 GCU, SOC 412 GCU, NSG 6440 SU, HIM 515 GCU, NSG 4029 SU, HIM 615 GCU, NSG 3029 SU, NSG 4055 SU, NSG 6630 SU, NSG 6005 SU, CRMJ 310, PSY 510 GCU, CRMJ 300 Devry, CRMJ 425, SPD 200 GCU, HLT 490 GCU ,ECH 340 GCU , ECH 440 GCU , ECH 355 GCU ,ECH 350 GCU ,LDR 461 GCU ,ECH 425 GCU ,REL 212 STR ,SCI 115 STR ,CIS 505 STR ,JUS 652 GCU, MGT 640 GCU, CIS 527 STR, SOC 436 GCU,ACC 502 GCU, FIN 504 GCU , MATH 260 DeVry ,ETHC 445 DeVry ,ECET 220 DeVry , CARD 405 DeVry, NETW 203 DeVry, NETW 205 DeVry, ECET 365 DeVry ,MATH 270 DeVry ,PHYS 310 DeVry, BIB 106 GCU ,CIS 512 STR ,SYM 506 GCU ,ECN 601 GCU  ,BIAM 570 DeVry, PSY 402 GCU , SOC 480 GCU , BIAM 530 DeVry