Question 1

What are the key steps in a data quality program?

Accepted Answer

There are several key steps to establish

Question 2

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)  none of the above. 
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)  none of the above.

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

High quality data are data that are:

Accepted Answer

A)  accurate. 
B)  consistent. 
C)  available in a timely fashion. 
D)  all of the above. 
A)  accurate. 
B)  consistent. 
C)  available in a timely fashion. 
D)  all of the above.

Question 5

Improving ________ is a fundamental step in data quality improvement.

Accepted Answer

data captu

Question 6

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:

Accepted Answer

A)  currency. 
B)  consistency. 
C)  referential Integrity. 
D)  timeliness. 
A)  currency. 
B)  consistency. 
C)  referential Integrity. 
D)  timeliness.

Question 7

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

Accepted Answer

The answer of User interaction integration is achieved by creating...

Question 8

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 9

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

Accepted Answer

The answer of Completeness means that all data that must...

Question 10

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

Accepted Answer

The answer of In the ________ approach,one consolidated record is...

Question 11

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

Accepted Answer

A)  it minimizes project delay. 
B)  it aids in making timely business decisions. 
C)  it provides a stream of profit. 
D)  it helps to expand the customer base. 
A)  it minimizes project delay. 
B)  it aids in making timely business decisions. 
C)  it provides a stream of profit. 
D)  it helps to expand the customer base.

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A)  Join index 
B)  Bit-mapped index 
C)  Secondary index 
D)  Both A and B 
A)  Join index 
B)  Bit-mapped index 
C)  Secondary index 
D)  Both A and B

Question 15

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

Accepted Answer

A)  static 
B)  incremental 
C)  partial 
D)  update-driven 
A)  static 
B)  incremental 
C)  partial 
D)  update-driven

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Quality data does not have to be unique.

Accepted Answer

A) True 
 B)False

Question 18

All of the following are ways to consolidate data EXCEPT:

Accepted Answer

A)  application integration. 
B)  data rollup and integration. 
C)  business process integration. 
D)  user interaction integration. 
A)  application integration. 
B)  data rollup and integration. 
C)  business process integration. 
D)  user interaction integration.

Question 19

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

Accepted Answer

The answer of A method of capturing data in a...

Question 20

Quality data can be defined as being:

Accepted Answer

A)  unique. 
B)  inaccurate. 
C)  historical. 
D)  precise. 
A)  unique. 
B)  inaccurate. 
C)  historical. 
D)  precise.

What are the key steps in a data quality program?

Data governance can be defined as:

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

High quality data are data that are:

Improving ________ is a fundamental step in data quality improvement.

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:

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

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

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

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

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

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

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

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

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

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

Quality data does not have to be unique.

All of the following are ways to consolidate data EXCEPT:

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

Quality data can be defined as being:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 10: Data Quality and Integration

What are the key steps in a data quality program?

Data governance can be defined as:

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

High quality data are data that are:

Improving ________ is a fundamental step in data quality improvement.

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:

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

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

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

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

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

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

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

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

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

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

Quality data does not have to be unique.

All of the following are ways to consolidate data EXCEPT:

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

Quality data can be defined as being:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

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