DATA WAREHOUSING QUIZ

Can be updated by end users.

Contains only current data.

Organized around important subject areas.

Contains numerous naming conventions and formats.

False

True

True

False

Many-to-many

All of these

One-to-one

One-to-many

A process to change data from a summary level to a detailed level

A process to change data from a detailed level to a summary level

Joining data from one source into various sources of data

Separating data from one source into various sources of data

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

Data stored in the various operational systems throughout the organization.

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

Data stored in one operational system in the organization.

Completely normalized

Completely denoralized

Partially normalized

Partially denoralized

A system that is used to run the business in real time and is based on current data.

A system that is used to support decision making and is based on historical data.

A system that is used to support decision making and is based on current data.

A system that is used to run the business in real time and is based on historical data.

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