DATA WAREHOUSING QUIZ

True

False

Partially denoralized

Completely denoralized

Completely normalized

Partially normalized

True

False

True

False

To explain some observed event or condition

To create a new data warehouse

To analyze data for expected relationships

To confirm that data exists

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

Separating data from one source into various sources of data

Joining data from one source into various sources of data

True

False

A process to load the data in the data warehouse and to create the necessary indexes

A process to upgrade the quality of data before it is moved into a data warehouse

A process to upgrade the quality of data after it is moved into a data warehouse

A process to reject data from the data warehouse and to create the necessary indexes

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

Capturing all of the data contained in various decision support systems

True

False