Question 1

What are some of the characteristics of quality data?

Accepted Answer

There are many characteristics that defi

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

What new trends and technologies have driven the need for changes in the data administration and database administration roles?

Accepted Answer

There have been several recent trends an

Question 4

Data governance can be defined as:

Accepted Answer

A)  a means to slow down the speed of data. 
B)  high-level organizational groups and processes that oversee data stewardship. 
C)  a government task force for defining data quality. 
D)  a means to increase the speed of data. 
A)  a means to slow down the speed of data. 
B)  high-level organizational groups and processes that oversee data stewardship. 
C)  a government task force for defining data quality. 
D)  a means to increase the speed of data.

Question 5

TQM stands for:

Accepted Answer

A)  Thomas Quinn Mann, a famous data quality innovator. 
B)  Total Quality Manipulation. 
C)  Transforming Quality Management. 
D)  Total Quality Management. 
A)  Thomas Quinn Mann, a famous data quality innovator. 
B)  Total Quality Manipulation. 
C)  Transforming Quality Management. 
D)  Total Quality Management.

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Completeness means that all data that are needed are present.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following functions model business rules?

Accepted Answer

A)  Database planning 
B)  Database analysis 
C)  Database design 
D)  Operations 
A)  Database planning 
B)  Database analysis 
C)  Database design 
D)  Operations

Question 9

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

Accepted Answer

A)  Avoid a data quality audit 
B)  Apply TQM principles and practices 
C)  Do not allow outside data 
D)  Keep all data on one server 
A)  Avoid a data quality audit 
B)  Apply TQM principles and practices 
C)  Do not allow outside data 
D)  Keep all data on one server

Question 10

Generally, records in a customer file never become obsolete.

Accepted Answer

A) True 
 B)False

Question 11

What are the key steps in a data quality program?

Accepted Answer

There are several key steps to establish

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A)  external data source 
B)  inconsistent metadata 
C)  data entry problem 
D)  lack of organizational commitment 
A)  external data source 
B)  inconsistent metadata 
C)  data entry problem 
D)  lack of organizational commitment

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Data quality problems can cascade when:

Accepted Answer

A)  data are not deleted properly. 
B)  data are copied from legacy systems. 
C)  there is redundant data storage and inconsistent metadata. 
D)  there are data entry problems. 
A)  data are not deleted properly. 
B)  data are copied from legacy systems. 
C)  there is redundant data storage and inconsistent metadata. 
D)  there are data entry problems.

Question 19

What factors should one consider when choosing an open source DBMS?

Accepted Answer

There are several factors to consider wh

Question 20

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

Accepted Answer

A) True 
 B)False

What are some of the characteristics of quality data?

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

What new trends and technologies have driven the need for changes in the data administration and database administration roles?

Data governance can be defined as:

TQM stands for:

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

Completeness means that all data that are needed are present.

Which of the following functions model business rules?

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

Generally, records in a customer file never become obsolete.

What are the key steps in a data quality program?

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

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

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

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

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

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

Data quality problems can cascade when:

What factors should one consider when choosing an open source DBMS?

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 12: Data and Database Administration With Focus on Data Quality

What are some of the characteristics of quality data?

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

What new trends and technologies have driven the need for changes in the data administration and database administration roles?

Data governance can be defined as:

TQM stands for:

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

Completeness means that all data that are needed are present.

Which of the following functions model business rules?

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

Generally, records in a customer file never become obsolete.

What are the key steps in a data quality program?

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

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

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

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

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

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

Data quality problems can cascade when:

What factors should one consider when choosing an open source DBMS?

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Distributed Databases

Object-Oriented Data Modeling

Filters