DATA WAREHOUSING QUIZ

All of these

One-to-many

One-to-one

Many-to-many

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

Data stored in one operational system in the organization.

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

Data stored in the various operational systems throughout the organization.

Completely denoralized

Partially denoralized

Partially normalized

Completely normalized

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 decision support systems

Capturing all of the data contained in various operational systems

False

True

Separating data from one source into various sources of data

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

Joining data from one source into various sources of data

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

All of these

Converts data from multiple fields into one field

Converts data from one field into multiple fields

Converts data from multiple fields into multiple fields

True

False

True

False

False

True