Exam 9: Data Warehousing

The analysis of summarized data to support decision making is called:

A data warehouse can be defined as a(n)________,________,________,________ collection of data used in support of management decision-making processes.

Which of the following data mining applications identifies customers for promotional activity?

Which of the following data mining techniques identifies clusters of observations with similar characteristics?

The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.

Explain the dependent data mart and operational data store architecture.

Explain what the Star schema is.

Which of the following is an objective of derived data?

The star schema is a simple database design in which ________ data are separated from ________ data.

Every key used to join the fact table with a dimension table should be a ________ key.

Which of the following data-mining techniques searches for patterns and correlations in large data sets?

Transient data are never changed.

A(n)________ is used to join a fact table with a dimension table.

What types of applications would benefit from real-time data warehousing?

Data that are never physically altered once they are added to the store are called ________ data.

The first requirement for building a user-friendly interface is a set of metadata that describes the data in the data mart in business terms that users can easily understand.

For performance reasons,it may be necessary to define more than one fact table for a star schema.

A data mart is a(n):

A conformed dimension is one or more dimension tables associated with only one fact table.

The intersection of primary keys is called the ________ of the fact table.