Chapter 9 Quiz

________ is an ill-defined term applied to databases where size strains the ability of commonly used relational DBMSs to manage the data.

Big data

Which of the following factors drive the need for data warehousing?

Businesses need an integrated view of company information.

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

Clustering and signal processing

data mart created by a relational view of a slightly denormalized data warehouse.

Data are immediately transformed and loaded into the warehouse.

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

Rule discovery

When we consider data in the data warehouse to be time-variant, we mean:

data in the warehouse contain a time dimension so that they may be used to study trends and changes.

A logical data mart is a(n):

data mart created by a relational view of a slightly denormalized data warehouse.

A data mart is a(n):

data warehouse that is limited in scope.

Going from a summary view to progressively lower levels of detail is called data:

drill-down.

Grain and duration have a direct impact on the size of ________ tables.

fact

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

informational processing.

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

integrated, subject-oriented, updateable, current-valued, detailed database designed to serve the decision support needs of operational users.

A dependent data mart:

is filled exclusively from the enterprise data warehouse with reconciled data.

All of the following are limitations of the independent data mart EXCEPT:

it is often more expedient to build a data mart than a data warehouse.

The use of a set of graphical tools that provides users with multidimensional views of their data is called:

on-line analytical processing (OLAP).

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

periodic

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

pivoting

Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data.

reconciled

Informational systems are designed for all of the following EXCEPT:

running a business in real time.

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

surrogate