Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

Bit-mapped indexing is often used in a data warehouse environment.

Accepted Answer

A) True 
 B)False  True

Question 3

What is data transformation?

Accepted Answer

Data transformation involves converting data in the format of the operational system into the format of the data warehouse. Data is accepted from the data capture component (after data scrubbing), is mapped to the format of the reconciled data layer, and then passed to the load and index component.

Question 4

What are some of the approaches to data integration?

Accepted Answer

Data integration creates a unified view

Question 5

Conformance refers to whether the data is stored, exchanged or presented in a format that is as specified by its metadata.

Accepted Answer

A) True 
 B)False

Question 6

What is the difference between an incremental extract and a static extract?

Accepted Answer

A static extract captures a sn

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Application integration is achieved by coordinating the flow of event information between business applications.

Accepted Answer

A) True 
 B)False

Question 9

One simple task of a data quality audit is to:

Accepted Answer

A)  interview all users. 
B)  statistically profile all files. 
C)  load all data into a data warehouse. 
D)  establish quality metrics. 
A)  interview all users. 
B)  statistically profile all files. 
C)  load all data into a data warehouse. 
D)  establish quality metrics.

Question 10

Static extract is a method of capturing only the changes that have occurred in the source data since the last capture.

Accepted Answer

A) True 
 B)False

Question 11

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 12

Discuss Master Data Management.

Accepted Answer

Master Data Management refers to the dis

Question 13

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 14

What are the key steps in a data quality program?

Accepted Answer

There are several key steps to establish

Question 15

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 16

An approach in which only changes in the source data are written to the data warehouse is called refresh mode.

Accepted Answer

A) True 
 B)False

Question 17

Data federation consolidates all data into one database.

Accepted Answer

A) True 
 B)False

Question 18

Quality data does not have to be unique.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

What are the record-level data transformation functions?

Accepted Answer

Record-level data transformation functio

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

Bit-mapped indexing is often used in a data warehouse environment.

What is data transformation?

What are some of the approaches to data integration?

Conformance refers to whether the data is stored, exchanged or presented in a format that is as specified by its metadata.

What is the difference between an incremental extract and a static extract?

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

Application integration is achieved by coordinating the flow of event information between business applications.

One simple task of a data quality audit is to:

Static extract is a method of capturing only the changes that have occurred in the source data since the last capture.

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

Discuss Master Data Management.

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

What are the key steps in a data quality program?

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

An approach in which only changes in the source data are written to the data warehouse is called refresh mode.

Data federation consolidates all data into one database.

Quality data does not have to be unique.

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

What are the record-level data transformation functions?

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

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

Bit-mapped indexing is often used in a data warehouse environment.

What is data transformation?

What are some of the approaches to data integration?

Conformance refers to whether the data is stored, exchanged or presented in a format that is as specified by its metadata.

What is the difference between an incremental extract and a static extract?

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

Application integration is achieved by coordinating the flow of event information between business applications.

One simple task of a data quality audit is to:

Static extract is a method of capturing only the changes that have occurred in the source data since the last capture.

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

Discuss Master Data Management.

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

What are the key steps in a data quality program?

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

An approach in which only changes in the source data are written to the data warehouse is called refresh mode.

Data federation consolidates all data into one database.

Quality data does not have to be unique.

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

What are the record-level data transformation functions?

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