Question 1

Datatype conflicts is an example of 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 2

What is a field-level transformation, and what different types exist?

Accepted Answer

A field-level function converts data fro

Question 3

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 4

Data quality ROI stands for:

Accepted Answer

A)  return on installation. 
B)  risk of incarceration. 
C)  rough outline inclusion. 
D)  rate of installation. 
A)  return on installation. 
B)  risk of incarceration. 
C)  rough outline inclusion. 
D)  rate of installation.

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Generally, records in a customer file never become obsolete.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Dirty data saves work for information systems projects.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  Joint index 
B)  Bit-mapped index 
C)  Secondary index 
D)  Tri-dex 
A)  Joint index 
B)  Bit-mapped index 
C)  Secondary index 
D)  Tri-dex

Question 10

Completeness means that all data that are needed are present.

Accepted Answer

A) True 
 B)False

Question 11

In the load and index stage of ETL, what is the difference between refresh mode and update mode?

Accepted Answer

Refresh mode is an approach to filling a

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  clients 
B)  networks 
C)  computers 
D)  user interfaces 
A)  clients 
B)  networks 
C)  computers 
D)  user interfaces

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A)  extracting. 
B)  updating. 
C)  joining. 
D)  aggregating. 
A)  extracting. 
B)  updating. 
C)  joining. 
D)  aggregating.

Question 17

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

Accepted Answer

A)  Table lookup 
B)  Cross-linking entities 
C)  Cross-linking attributes 
D)  Field-to-field communication 
A)  Table lookup 
B)  Cross-linking entities 
C)  Cross-linking attributes 
D)  Field-to-field communication

Question 18

Conformance means that:

Accepted Answer

A)  data have been transformed. 
B)  data are stored, exchanged or presented in a format that is specified by its metadata. 
C)  data are stored in a way to expedite retrieval. 
D)  data is a harbinger. 
A)  data have been transformed. 
B)  data are stored, exchanged or presented in a format that is specified by its metadata. 
C)  data are stored in a way to expedite retrieval. 
D)  data is a harbinger.

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)  extracting. 
B)  updating. 
C)  selecting. 
D)  joining. 
A)  extracting. 
B)  updating. 
C)  selecting. 
D)  joining.

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

What is a field-level transformation, and what different types exist?

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

Data quality ROI stands for:

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

Generally, records in a customer file never become obsolete.

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

Dirty data saves work for information systems projects.

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

Completeness means that all data that are needed are present.

In the load and index stage of ETL, what is the difference between refresh mode and update mode?

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

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

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

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

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

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

Conformance means that:

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

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 10: Data Quality and Integration

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

What is a field-level transformation, and what different types exist?

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

Data quality ROI stands for:

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

Generally, records in a customer file never become obsolete.

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

Dirty data saves work for information systems projects.

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

Completeness means that all data that are needed are present.

In the load and index stage of ETL, what is the difference between refresh mode and update mode?

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

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

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

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

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

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

Conformance means that:

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

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters