Question 1

The process of partitioning data according to predefined criteria is called aggregation.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Data may be loaded from the staging area into the warehouse by following:

Accepted Answer

A)  SQL Commands (Insert/Update). 
B)  SQL purge. 
C)  custom-written letters. 
D)  virus checking. 
A)  SQL Commands (Insert/Update). 
B)  SQL purge. 
C)  custom-written letters. 
D)  virus checking.

Question 5

The major advantage of the data propagation approach to data integration is the near real-time cascading of data changes throughout the organization.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

Quality data are not essential for well-run organizations.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)  Variable Data Management. 
B)  Master Data Management. 
C)  Joint Data Management. 
D)  Managed Data Management. 
A)  Variable Data Management. 
B)  Master Data Management. 
C)  Joint Data Management. 
D)  Managed Data Management.

Question 13

Event-driven propagation:

Accepted Answer

A)  provides a means to duplicate data for events. 
B)  pushes data to duplicate sites as an event occurs. 
C)  pulls duplicate data from redundant sites. 
D)  triggers a virus. 
A)  provides a means to duplicate data for events. 
B)  pushes data to duplicate sites as an event occurs. 
C)  pulls duplicate data from redundant sites. 
D)  triggers a virus.

Question 14

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

Accepted Answer

A)  Identity Registry. 
B)  Integration Hub. 
C)  Persistent. 
D)  Normalization. 
A)  Identity Registry. 
B)  Integration Hub. 
C)  Persistent. 
D)  Normalization.

Question 15

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 16

Update mode is used to create a data warehouse.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Loading data into a data warehouse does NOT involve:

Accepted Answer

A)  appending new rows to the tables in the warehouse. 
B)  updating existing rows with new data. 
C)  purging data that have become obsolete or were incorrectly loaded. 
D)  formatting the hard drive. 
A)  appending new rows to the tables in the warehouse. 
B)  updating existing rows with new data. 
C)  purging data that have become obsolete or were incorrectly loaded. 
D)  formatting the hard drive.

Question 19

A technique using artificial intelligence to upgrade the quality of raw data is called:

Accepted Answer

A)  dumping. 
B)  data reconciliation. 
C)  completion backwards updates. 
D)  data scrubbing. 
A)  dumping. 
B)  data reconciliation. 
C)  completion backwards updates. 
D)  data scrubbing.

Question 20

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.

The process of partitioning data according to predefined criteria is called aggregation.

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

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

Data may be loaded from the staging area into the warehouse by following:

The major advantage of the data propagation approach to data integration is the near real-time cascading of data changes throughout the organization.

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

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

TQM stands for:

Data governance can be defined as:

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

Quality data are not essential for well-run organizations.

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

Event-driven propagation:

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

Data quality problems can cascade when:

Update mode is used to create a data warehouse.

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

Loading data into a data warehouse does NOT involve:

A technique using artificial intelligence to upgrade the quality of raw data is called:

All of the following are tasks of data cleansing EXCEPT:

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

The process of partitioning data according to predefined criteria is called aggregation.

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

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

Data may be loaded from the staging area into the warehouse by following:

The major advantage of the data propagation approach to data integration is the near real-time cascading of data changes throughout the organization.

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

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

TQM stands for:

Data governance can be defined as:

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

Quality data are not essential for well-run organizations.

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

Event-driven propagation:

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

Data quality problems can cascade when:

Update mode is used to create a data warehouse.

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

Loading data into a data warehouse does NOT involve:

A technique using artificial intelligence to upgrade the quality of raw data is called:

All of the following are tasks of data cleansing EXCEPT:

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