Exam 10: Data Quality and Integration

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.

Data quality ROI stands for:

A data stewardship program does not help to involve the organization in data quality.

The major advantage of the data propagation approach to data integration is the near real-time cascading of data changes throughout the organization.

Loading data into a data warehouse involves:

Completeness means that all data that are needed are present.

All of the following are popular architectures for Master Data Management EXCEPT:

The process of partitioning data according to predefined criteria is called ________.

Sound data ________ is a central ingredient of a data quality program.

________ provides a virtual view of integrated data without actually bringing the data into one physical database.

What is the difference between an incremental extract and a static extract?

________ is achieved by coordinating the flow of event information between business applications.

One simple task of a data quality audit is to:

A data governance committee is always made up of high-ranking government officials.

________ can cause delays and extra work on information systems projects.

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

Generally,records in a customer file never become obsolete.

One of the biggest challenges of the extraction process is managing changes in the source system.

ETL is short for Extract,Tranform,Load.

A(n)________ will thoroughly review all process controls on data entry and maintenance.