asdf10

Which of the following are key steps in a data quality program?

Apply TQM principles and practices.

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

Bit-mapped index

________ duplicates data across databases.

Data propagation

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

Master Data Management.

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

Normalization

Which of the following is a basic method for single field transformation?

Table lookup

TQM stands for:

Total Quality Management.

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

aggregating

One way to improve the data capture process is to:

check entered data immediately for quality against data in the database

A characteristic of reconciled data that means the data reflect an enterprise-wide view is:

comprehensive

All of the following are tasks of data cleansing EXCEPT:

creating foreign keys.

Data quality problems can cascade when:

data are copied from legacy systems.

Conformance means that:

data are stored, exchanged or presented in a format that is specified by its metadata.

Including data capture controls (i.e., dropdown lists) helps reduce ________ deteriorated data problems.

data entry

All of the following are ways to consolidate data EXCEPT:__

data rollup and integration.

A technique using artificial intelligence to upgrade the quality of raw data is called:

data scrubbing

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

data scrubbing.

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

data transformation.

Datatype conflicts is an example of a(n) ________ reason for deteriorated data quality.

external data source.

Getting poor data from a supplier is a(n) ________ reason for deteriorated data quality.

external data source.

Loading data into a data warehouse does NOT involve:

formatting the hard drive.

Data governance can be defined as:

high-level organizational groups and processes that oversee data stewardship.

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

high-quality.

The best place to improve data entry across all applications is:

in the database definitions.

A method of capturing only the changes that have occurred in the source data since the last capture is called ________ extract.

incremental

Data quality is important for all of the following reasons EXCEPT:

it provides a stream of profit.

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

joining

Informational and operational data differ in all of the following ways EXCEPT:

level of detail.

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

persistent

In the ________ approach, one consolidated record is maintained, and all applications draw on that one actual "golden" record.

persistent

Data federation is a technique which:

provides a virtual view of integrated data without actually creating one centralized database.

Event-driven propagation:

pushes data to duplicate sites as an event occurs.

The major advantage of data propagation is

real-time cascading of data changes throughout the organization.

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

refresh mode.

Data quality ROI stands for:

risk of incarceration.

One simple task of a data quality audit is to:

statistically profile all files.

External data sources present problems for data quality because:

there is a lack of control over data quality.

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:

timeliness

Quality data can be defined as being:

unique

User interaction integration is achieved by creating fewer ________ that feed different systems.

user interfaces