HOMEWORK - 1

A data warehouse is which of the following?

A.Can be updated by end users.

B.Contains numerous naming conventions and formats.

C.Organized around important subject areas.

D.Contains only current data.

An operational system is which of the following?

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

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

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

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

Fact tables are which of the following?

A.Completely denoralized

B.Partially denoralized

C.Completely normalized

D.Partially normalized

Data transformation includes which of the following?

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

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

C.Joining data from one source into various sources of data

D.Separating data from one source into various sources of data

The extract process is which of the following?

A.Capturing all of the data contained in various operational systems

B.Capturing a subset of the data contained in various operational systems

C.Capturing all of the data contained in various decision support systems

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