Business Intelligence Reading Quiz: Test Your Knowledge!

Reading quiz #2 MSBA.305.C1 Business Intelligence Started on State Compl eted on Time taken Grade 15.00 out of 15.00 (100%) Question 1 Complete 1.00 points out of 1.00 Flag question Question text Which of the following measure is not a valid type defined in facts? Select one: a. Semi-additive facts b. Additive facts c. Non-additive facts d. none, all are valid Feedback The correct answer is: none, all are valid Question 2 Complete

1.00 points out of 1.00 Flag question Question text Which of the following schema is the most frequently used schema for dimensional models: Select one: a. Star schema b. Snowflake Schema c. Multi-dimensional Schema d. Combined Schema Feedback The correct answer is: Star schema Question 3 Complete 1.00 points out of 1.00 Flag question Question text Which of the following is the benefit of using Date/Time Dimension Select one: a. Improve query speed b. Increase consistency of the dataset c. Increase productivity for both business people and information technology staff d. All of the above

Feedback The correct answer is: All of the above Question 4 Complete 1.00 points out of 1.00 Flag question Question text When an enterprise's operations span multiple time-zones, which of the following is the best practice to implement a database? Select one: a. Storing the time zone indicators or hour offset from a baseline, which rely on manual coding in the BI applications b. Recording time in two fact columns with different time zones, which are local time and GMT, respectively. c. Ignore time difference and use GMT as a standard d. Calculate the difference and use any standard time Feedback The correct answer is: Recording time in two fact columns with different time zones, which are local time and GMT, respectively. Question 5 Complete 1.00 points out of 1.00 Flag question Question text Which of the following relationship(s) is not valid in dimension hierarchy? Select one: a. Product and Product Category

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

b. Geographic groups such as sales territories c. Time, Years break down to quarters, months, weeks, etc. d. All of the above are valid Feedback The correct answer is: All of the above are valid Question 6 Complete 1.00 points out of 1.00 Flag question Question text The 5 C's of data are: Select one: a. Consistent, clean, concise, current, & compounded b. Consistent, clean, comprehensive, conformed & current c. consistent, clean, complete, confirmed, & confounded d. Consistent, clean, controlled, compared, & current Feedback The correct answer is: Consistent, clean, comprehensive, conformed & current Question 7 Complete 1.00 points out of 1.00 Flag question Question text CIF is an abbreviation for what (wrt Data Architecture)

Select one: a. Central Information Fact b. Common Information Factory c. Collective Intelligence Framework d. Corporate Information Factory Feedback The correct answer is: Corporate Information Factory Question 8 Complete 1.00 points out of 1.00 Flag question Question text The book recommends which data architecture: Select one: a. Enterprise Data Warehouse b. Independent Data Marts c. Enterprise data bus architecture d. Hub-and-spoke, corporate information factory e. Analytical data architecture Feedback The correct answer is: Analytical data architecture

Question 9 Complete 1.00 points out of 1.00 Flag question Question text The Enterprise Data Warehouse is split into what schemas? Select one or more: a. Data distribution b. data architecture c. data integration d. data usage Feedback The correct answers are: Data distribution, data integration Question 10 Complete 1.00 points out of 1.00 Flag question Question text Which of the following is true Select one: a. Once created, the data marts will keep on being updated from the data warehouse at periodic times b. Once created, the data marts will directly receive their new data from the operational databases c.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

The data marts are different groups of tables in the data warehouse d. A data mart becomes a data warehouse when it reaches a critical size Feedback The correct answer is: Once created, the data marts will keep on being updated from the data warehouse at periodic times Question 11 Complete 1.00 points out of 1.00 Flag question Question text Enterprises with both an EDW and an ODS could have reports that access data from Select one: a. ODS only b. EDW only c. ODS and EDW d. All of the above Feedback The correct answer is: All of the above Question 12 Complete 1.00 points out of 1.00 Flag question Question text What layers of data enable Business Intelligence? Select one or more: a.

SOR b. SOI c. SOD d. SOA e. SOB Feedback The correct answers are: SOR, SOI, SOA Question 13 Complete 1.00 points out of 1.00 Flag question Question text ___________ enables you to provide detailed documentation of the workflow of data from source systems through information consumption Select one: a. Recovery and restart b. Data Quality c. Referential integrity d. Auditing Feedback The correct answer is: Auditing Question 14

Complete 1.00 points out of 1.00 Flag question Question text What are the characteristics of an ODS? Select one: a. Integrates data from multiple source systems b. Enables consolidated reporting c. Offeres pre-built reporting or integration solution for enterprise applications d. All of the above Feedback The correct answer is: All of the above Question 15 Complete 1.00 points out of 1.00 Flag question Question text With the analytical data architecture, data is processed in what order? Select one: a. BI, SOI, SOA, SOR b. SOR, SOI, SOA, BI c. BI, SOA, SOI, SOR d.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

SOI, SOR, BI, SOA Feedback The correct answer is: SOR, SOI, SOA, BI

Reading quiz #2

Related Documents