Exam 10: Data Quality and Integration

Total quality management (TQM) focuses on defect correction rather than defect prevention.

What are some of the reasons for deteriorated data quality?

The uncontrolled proliferation of spreadsheets, databases and repositories leads to data quality problems.

In the ________ approach, one consolidated record is maintained from which all applications draw data.

Data federation is a technique which:

________ duplicates data across databases.

Data scrubbing is a technique using pattern recognition and other artificial intelligence techniques to upgrade the quality of raw data before transforming and moving the data to the data warehouse.

One characteristic of quality data which pertains to the expectation for the time between when data are expected and when they are available for use is:

An approach to filling a data warehouse that employs bulk rewriting of the target data periodically is called:

A method of capturing data in a snapshot at a point in time is called static extract.

Discuss the ETL process.

The process of transforming data from detailed to summary levels is called normalization.

What are the characteristics of data after ETL?

Refresh mode is an approach to filling the data warehouse that employs bulk rewriting of the target data at periodic intervals.

Data that are accurate, consistent, and available in a timely fashion are considered:

Data reconciliation occurs in two stages, an initial load and subsequent updates.

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

One way to improve the data capture process is to:

Quality data can be defined as being:

ETL is short for Extract, Transform, Load.