(Database) Chapter 10

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

Data federation

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

True

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.

True

ETL is short for Extract, Tranform, Load.

True

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

True

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

True

User interaction integration is achieved by creating fewer user interfaces.

True

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

aggregation

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

data transformation

A(n) ________ function converts data from a given format in a source record to a different format in a target record

field-level

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

selection

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

static

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

Application integration

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

Dirty data

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

F... fawk this class

There are six major steps to ETL.

False

A data quality audit helps an organization understand the extent and nature of data quality problems.

True

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

True

Bit-mapped indexing is often used in a data warehouse environment.

True

Completeness means that all data that are needed are present.

True

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

True

The data reconciliation process is responsible for transforming operational data to reconciled data.

True

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

user interfaces

Completeness means that all data that must have a ________ does have a ________.

value, value

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

False

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

False

After the extract, transform, and load is done on data, the data warehouse is never fully normalized.

False

Data are moved to the staging area before extraction takes place.

False

Data federation consolidates all data into one database.

False

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

False

Data which arrive via XML and B2B channels is always guaranteed to be accurate

False

Dirty data saves work for information systems projects

False

Generally, records in a customer file never become obsolete.

False

Master data management is the disciplines, technologies and methods to ensure the currency, meaning and quality of data within one subject area.

False

Quality data are not essential for well-run organizations.

False

Quality data does not have to be unique.

False

Retention refers to the amount of data that is not purged periodically from tables.

False

Static extract is a method of capturing only the changes that have occurred in the source data since the last capture.

False

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

False

Update mode is used to create a data warehouse.

False

Data quality is essential for SOX and Basel II compliance

True

Joining is often complicated by problems such as errors in source data.

True

Loading data into the warehouse typically means appending new rows to tables in the warehouse as well as updating existing rows with new data.

True

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

True

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

audit

Improving ________ is a fundamental step in data quality improvement.

data capture processes

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

data scrubbing

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

data steward

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

metadata

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

modeling

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

persistent

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

real-time

An approach in which only changes in the source data are written to the data warehouse is called ________

update mode