DATA WAREHOUSING QUIZ

Data that are never deleted once they have been added

Data in which changes to existing records cause the previous version of the records to be eliminated

Data in which changes to existing records do not cause the previous version of the records to be eliminated

Data that are never altered or deleted once they have been added

False

True

Data stored in the various operational systems throughout the organization.

Data stored in one operational system in the organization.

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

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

False

True

True

False

False

True

To analyze data for expected relationships

To explain some observed event or condition

To confirm that data exists

To create a new data warehouse

All of these

Dimension

Helper

Fact

True

False

True

False