Quiz: Chapter 13 Business Intelligence and Data Warehouses

1. Which of the following best defines business intelligence?

 A comprehensive set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information to support business decision making

2. Which of the following is NOT a component of basic business intelligence architecture?

 Data monitoring and performance

3. Which of the following statements is false?

OLAP stands for online application processing and provides multidimensional data analysis

4. The following is a list of business intelligence technology trends except for _____.

business intelligence applications

5. Which of the following statements is false?

Data warehouse is an integrated, object-oriented, time-variant, volatile collection of data that provides support for decision making.

6. Which of the following is an invalid term of star schema?

 Metrics: the measurements (values) that measure a specific business aspect or activity

7. Which statement is not true about a snowflake schema?

Snowflake schema is a type of star schema in which the fact table can have its own dimension tables

8. What are the three components of OLAP architecture?

Graphical user interface, analytical processing logic, and data-processing logic

9. What are the phases of data mining?

Data Preparation, Data Analysis, Knowledge Acquisition, and Prognosis

10. Which of the following is NOT a data visualization technique?

Geographic: use of geographical mapping

Chapter 13 Use It

  1. Match the following terms with a short description of that term

2. Use the following scenario for questions from this chapter:

Consider the Business Intelligence Framework presented in Chapeter-13 (Figure 13-1). The figure presents various components of B.I to augment intelligent decision making on-time. ‘B.I’ has become the integrating umbrella for a disparate mix of IT systems within an organization. This architecture supports all types of company-generated data from operations to the executives, as well as diverse computers such as mainframes, servers, desktops, laptops, and mobile devices.

Keeping in mind the integral role of an enterprise database to augment an effective B.I platform, match the following words or phrases with terms, definitions or concepts discussed in Chapter-13.

Other Links:

Statistics Quiz

Networking Quiz

See other websites for quiz:

Check on QUIZLET

Check on CHEGG

 


Leave a Reply

Your email address will not be published. Required fields are marked *