DATA WAREHOUSING QUIZ

True

False

All of these

Near real-time updates

Data that can extracted from numerous internal and external sources

At least one data mart

Capturing all of the data contained in various decision support systems

Capturing a subset of the data contained in various operational systems

Capturing a subset of the data contained in various decision support systems

Capturing all of the data contained in various operational systems

Helper

Dimension

Fact

All of these

Organized around important subject areas.

Can be updated by end users.

Contains only current data.

Contains numerous naming conventions and formats.

Current data intended to be the single source for all decision support systems.

Data that has been selected and formatted for end-user support applications.

Data stored in one operational system in the organization.

Data stored in the various operational systems throughout the organization.

True

False

A process to upgrade the quality of data before 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 after it is moved into a data warehouse

True

False

False

True