DATA WAREHOUSING QUIZ

All of these

Data that can extracted from numerous internal and external sources

At least one data mart

Near real-time updates

True

False

All of these

Dimension

Fact

Helper

True

False

Data stored in one operational system in the organization.

Data stored in the various operational systems throughout the organization.

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.

True

False

True

False

At least one data mart

Near real-time updates

Data that can extracted from numerous internal and external sources

All of these

To analyze data for expected relationships

To confirm that data exists

To explain some observed event or condition

To create a new data warehouse

Capturing a subset of the data contained in various operational systems

Capturing all of the data contained in various operational systems

Capturing all of the data contained in various decision support systems

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