Exam 9: Data Warehousing and Data Integration

Data propagation duplicates data across databases, usually with some real-time delay.

The representation of data in a graphical format is called data mining.

What are the record-level data transformation functions?

Transient data are never changed.

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

Static extract is a method of capturing only the changes that have occurred in the source data since the last capture.

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

All of the following are ways to handle changing dimensions EXCEPT:

Explain the dependent data mart and operational data store architecture.

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

User interaction integration is achieved by creating fewer user interfaces.

A dependent data mart is filled from the enterprise data warehouse and its reconciled data.

Which type of index is commonly used in data warehousing environments?

An enterprise data warehouse is the control point and single source of all data made available to end users for decision support applications.

Loading data into the warehouse typically means appending new rows to tables in the warehouse as well as updating existing rows with new data.

The analysis of data or information to support decision making is called:

Discuss the limitations of the independent data mart architecture.

A technique using pattern recognition to upgrade the quality of raw data is called:

When multiple systems in an organization are synchronized, the need for data warehousing increases.

Medical claims and pharmaceutical data would be an example of big data.