Database chapter 12

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

Apply TQM principles and practices

________ is a technical function responsible for database design, security, and disaster recovery.

Database administration

Which of the following functions model business rules?

Database analysis

Which of the following functions design integrity controls?

Database design

Which of the following functions do cost/benefit models?

Database planning

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

False

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

A high-level function that is responsible for the overall management of data resources in an organization is called database administration.

False

A review will thoroughly review all process controls on data entry and maintenance.

False

Completeness means that all data that must have a value does not have a value.

False

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

False

Databases are generally the property of a single department within an organization.

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

Open source software always comes with complete documentation.

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

Specifications for transactions do not need to be reviewed quickly.

False

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

False

Which of the following is NOT true of poor data and/or database administration?

Maintaining a secure server

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

Master Data Management.

TQM stands for:

Total Quality Management.

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

Completeness means that all data that are needed are present.

True

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

True

Data quality is essential for SOX and Basel II compliance.

True

Dirty data can cause delays and extra work on information systems projects.

True

Improving data capture process is a fundamental step in data quality improvement.

True

Lack of organizational commitment is a potential reason for an organization's deteriorated data quality.

True

Open source DBMS are free software that provide the core functionality of an SQL compliant DBMS.

True

Sound data modeling is a central ingredient of a data quality program

True

Specifying database access policies is done during the database implementation phase.

True

The data administrator takes responsibility for the overall management of data resources.

True

The role of database administration is typically a more hands-on, physical involvement with the management of databases.

True

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

True

An open source DBMS is:

a free source code RBMS that provides the functionality of an SQL-compliant DBMS.

One way to improve the data capture process is to:

check entered data immediately for quality against data in the database.

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

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

external data source

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.

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

it provides a stream of profit.

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

normalization.

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 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.