Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)  Conduct a data quality audit 
B)  Apply TQM principles and practices 
C)  Estimate return on investment 
D)  All of the above 
A)  Conduct a data quality audit 
B)  Apply TQM principles and practices 
C)  Estimate return on investment 
D)  All of the above

Question 3

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

Accepted Answer

The answer of A(n)________ function converts data from a given...

Question 4

There are six major steps to ETL.

Accepted Answer

A) True 
 B)False

Question 5

Quality data are not essential for well-run organizations.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Update mode is used to create a data warehouse.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

The best place to improve data entry across all applications is:

Accepted Answer

A)  in the users. 
B)  in the level of organizational commitment. 
C)  in the database definitions. 
D)  in the data entry operators. 
A)  in the users. 
B)  in the level of organizational commitment. 
C)  in the database definitions. 
D)  in the data entry operators.

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

In the ________ approach,one consolidated record is maintained and all applications draw on that one actual "golden" record.

Accepted Answer

A)  Persistent 
B)  Identity Registry 
C)  Federated 
D)  Integration Hub 
A)  Persistent 
B)  Identity Registry 
C)  Federated 
D)  Integration Hub

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Data federation consolidates all data into one database.

Accepted Answer

A) True 
 B)False

Question 15

All of the following are tasks of data cleansing EXCEPT:

Accepted Answer

A)  decoding data to make them understandable for data warehousing applications. 
B)  adding time stamps to distinguish values for the same attribute over time. 
C)  generating primary keys for each row of a table. 
D)  creating foreign keys. 
A)  decoding data to make them understandable for data warehousing applications. 
B)  adding time stamps to distinguish values for the same attribute over time. 
C)  generating primary keys for each row of a table. 
D)  creating foreign keys.

Question 16

What are some of the reasons for deteriorated data quality?

Accepted Answer

There are several reasons for the deteri

Question 17

Why is data quality important?

Accepted Answer

Data quality is important to minimize IT

Question 18

A characteristic of reconciled data that means the data reflect an enterprise-wide view is:

Accepted Answer

A)  detailed. 
B)  historical. 
C)  normalized. 
D)  comprehensive. 
A)  detailed. 
B)  historical. 
C)  normalized. 
D)  comprehensive.

Question 19

The major advantage of data propagation is:

Accepted Answer

A)  real-time cascading of data changes throughout the organization. 
B)  duplication of non-redundant data. 
C)  the ability to have trickle-feeds. 
D)  none of the above. 
A)  real-time cascading of data changes throughout the organization. 
B)  duplication of non-redundant data. 
C)  the ability to have trickle-feeds. 
D)  none of the above.

Question 20

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

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

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

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

There are six major steps to ETL.

Quality data are not essential for well-run organizations.

Data quality problems can cascade when:

Update mode is used to create a data warehouse.

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

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

The best place to improve data entry across all applications is:

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

In the ________ approach,one consolidated record is maintained and all applications draw on that one actual "golden" record.

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

Data federation consolidates all data into one database.

All of the following are tasks of data cleansing EXCEPT:

What are some of the reasons for deteriorated data quality?

Why is data quality important?

A characteristic of reconciled data that means the data reflect an enterprise-wide view is:

The major advantage of data propagation is:

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

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

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

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

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

There are six major steps to ETL.

Quality data are not essential for well-run organizations.

Data quality problems can cascade when:

Update mode is used to create a data warehouse.

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

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

The best place to improve data entry across all applications is:

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

In the ________ approach,one consolidated record is maintained and all applications draw on that one actual "golden" record.

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

Data federation consolidates all data into one database.

All of the following are tasks of data cleansing EXCEPT:

What are some of the reasons for deteriorated data quality?

Why is data quality important?

A characteristic of reconciled data that means the data reflect an enterprise-wide view is:

The major advantage of data propagation is:

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

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