question

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

answer

data rollup and integration.

question

Data governance can be defined as:

answer

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

question

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:

answer

timeliness

question

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

answer

data transformation.

question

External data sources present problems for data quality because:

answer

there is a lack of control over data quality.

question

Conformance means that:

answer

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

question

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

answer

data entry

question

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

answer

joining

question

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

answer

level of detail.

question

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

answer

data scrubbing

question

TQM stands for:

answer

Total Quality Management.

question

Quality data can be defined as being:

answer

unique

question

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

answer

it provides a stream of profit.

question

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

answer

data scrubbing.

question

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

answer

aggregating

question

All of the following are tasks of data cleansing EXCEPT:

answer

creating foreign keys.

question

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

answer

high-quality.

question

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

answer

comprehensive

question

The major advantage of data propagation is

answer

real-time cascading of data changes throughout the organization.

question

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

answer

user interfaces

question

Event-driven propagation:

answer

pushes data to duplicate sites as an event occurs.

question

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

answer

persistent

question

________ duplicates data across databases.

answer

Data propagation

question

One way to improve the data capture process is to:

answer

check entered data immediately for quality against data in the database

question

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

answer

Apply TQM principles and practices.

question

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

answer

Master Data Management.

question

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

answer

external data source.

question

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

answer

Bit-mapped index

question

Data quality problems can cascade when:

answer

data are copied from legacy systems.

question

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

answer

persistent

question

Data federation is a technique which:

answer

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

question

One simple task of a data quality audit is to:

answer

statistically profile all files.

question

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

answer

incremental

question

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

answer

Table lookup

question

Loading data into a data warehouse does NOT involve:

answer

formatting the hard drive.

question

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

answer

external data source.

question

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

answer

Normalization

question

Data quality ROI stands for:

answer

risk of incarceration.

question

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

answer

in the database definitions.

question

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

answer

refresh mode.

asdf10 – College Essay

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards