Data WareHouse Concepts

Fact tables are which of the following?

Completely denoralized

Partially denoralized

Completely normalized

Partially normalized

A star schema has what type of relationship between a fact and dimension table?

Many-to-many

One-to-one

One-to-many

All of the above.

Data scrubbing is which of the following?

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

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

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

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

A data warehouse is which of the following?

Can be updated by end users

Contains numerous naming conventions and formats

Organized around important subject areas

Contains only current data

Which of the following is not a component of a data warehouse?

Metadata

Current detail data

Lightly summarized data

Component Key

Which of the following is not a kind of data warehouse application?

Information processing

Analytical processing

Data mining

Transaction processing

In Star Schema Dimension tables are:

Short and Fat

Long and Thin

Long and Fat

Short and thin

Which of the following features usually applies to data in a Data Warehouse?

Data are often deleted

Most applications consists of transactions

Data are rarely deleted

Relatively few records are processed by applications

Which of the following statement is true?

The data warehouse consists of data marts and operational data

The data warehouse is used as a source for operational data

The operational data are used as a source for the data warehouse

All of the above

More Surveys