Exam 10: Data Quality and Integration

A ________ is a person assigned the responsibility of ensuring that organizational applications properly support the organization's enterprise goals of data quality.

What is a field-level transformation and what different types exist?

TQM stands for:

Event-drive propagation:

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

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

What are the characteristics of data after ETL?

Data transformation is not an important part of the data reconciliation process.

Converting data from the format of its source to the format of its destination is called ________.

________ duplicates data across databases.

Data propagation duplicates data across databases,usually with no ________ delay.

What are some of the approaches to data integration?

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

What are some of the characteristics of quality data?

Conformance refers to whether the data is stored,exchanged or presented in a format that is as specified by its ________.

The methods to ensure the quality of data across various subject areas are called:

Data federation is a technique which:

What are the record-level data transformation functions?

The process of transforming data from a detailed to a summary level is called:

The process of combining data from various sources into a single table or view is called: