DATA WAREHOUSING QUIZ

Periodic data are data that are physically altered once added to the store.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Independent data marts are often created because an organization focuses on a series of short-term business objectives.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Both status data and event data can be stored in a database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Data in the data warehouse are loaded and refreshed from operational systems.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Data scrubbing is which of the following?

A process to upgrade the quality of data after it is moved into a data warehouse

A process to load the data in the data warehouse and to create the necessary indexes

A process to reject data from the data warehouse and to create the necessary indexes

A process to upgrade the quality of data before it is moved into a data warehouse

TRUE ANSWER : ?
YOUR ANSWER : ?

The @active data warehouse architecture includes which of the following?

Data that can extracted from numerous internal and external sources

At least one data mart

Near real-time updates

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

Data in operational systems are typically fragmented and inconsistent.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Every key used to join the fact table with a dimensional table should be a surrogate key.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑