Pop Quiz Chapter 8-H

A data warehouse is a __________ collection of information-gathered from many

different _____________ databases-that supports business analysis activities and

decision-making tasks.

• physical, transactional

• physical, operational

• logical, transactional

• logical, operational

What is data mining?

• A common term for the representation of multidimensional information.

• A particular attribute of information.

• A techniques to find patterns and relationships in large volumes of

  information and infer rules from them that predict future behavior and guide

  decision making.

• A process of analyzing data to extract information not offered by the raw data

  alone.

What do data warehouses support?

• OLAP

• Analytical processing

• OLTP

• OLAP and analytical processing

Which of the following not describes ETL?

• A process that extracts information from internal and external databases

• A process that transforms information using a common set of enterprise definitions

• A process that loads information into a data warehouse

• A decision making process

When does information cleansing occur in the data warehouse?

• During the ETL process

• On the information, once it is in the data warehouse

• During the ETL process and once it is in the data warehouse

• During the ETL process and before it is in the data warehouse

Which of the following statements is true regarding customer information?

• Customer information can exist in several operational systems

• Customer information in each operational system could change

• Customer information in each operational system can be different

• None of the above

Which of the following occurs during data cleansing?

• Clean accurate records

• Clean all information

• Clean inaccurate data

• Clean complete data

What is information that people use to support their decision-making efforts?

• Information cleansing and scrubbing

• Data-mining tools

• Business intelligence

• Data mining

Which of the following is not one of the principal BI enablers?

• Technology

• Corporate processes

• People

• Corporate culture

Extraction, transformation, and loading is a process that extracts information from internal databases, transforms the information using a common set of enterprise definitions, and loads the information into an external database.

• True

• False