Exam 9: Data Warehousing

A data mart is a(n):

Independent data marts do not generally lead to redundant data and efforts.

Rotating the view of a multidimensional database for a particular data point is called data:

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

________ technologies are allowing more opportunities for real-time data warehouses.

A corporate information factory (CIF) is a comprehensive view of organizational data in support of all user data requirements.

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

When determining the size of a fact table, estimating the number of possible values for each dimension associated with the fact table is equivalent to:

What is OLAP and what types of OLAP tools are available?

Scalable technology is critical to a data mart.

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

What is data mining, and what are its goals?

A data mart is a data warehouse that contains data that can be used across the entire organization.

A class of database technology used to store textual and other unstructured data is called:

An operational data store (ODS) is a(n):

There are applications for fact tables without any nonkey data, only the foreign keys for the associated dimensions.

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

Informational systems are designed to support decision making based on historical point-in-time and prediction data.

Discuss the four key terms (subject-oriented, integrated, time-variant, and nonupdateable) related to data warehousing.

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