Question 1

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 2

Retention refers to the amount of data that is not purged periodically from tables.

Accepted Answer

A) True 
 B)False

Question 3

Informational and operational data differ in all of the following ways EXCEPT:

Accepted Answer

A)  level of detail. 
B)  normalization level. 
C)  scope of data. 
D)  data quality. 
A)  level of detail. 
B)  normalization level. 
C)  scope of data. 
D)  data quality.

Question 4

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

Accepted Answer

A)  SQL Commands (Insert/Update). 
B)  special load utilities. 
C)  custom-written routines. 
D)  all of the above. 
A)  SQL Commands (Insert/Update). 
B)  special load utilities. 
C)  custom-written routines. 
D)  all of the above.

Question 5

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

Accepted Answer

The answer of An approach in which only changes in...

Question 6

One way to improve the data capture process is to:

Accepted Answer

A)  allow all data to be entered manually. 
B)  provide little or no training to data entry operators. 
C)  check entered data immediately for quality against data in the database. 
D)  not use any automatic data entry routines. 
A)  allow all data to be entered manually. 
B)  provide little or no training to data entry operators. 
C)  check entered data immediately for quality against data in the database. 
D)  not use any automatic data entry routines.

Question 7

Data quality is essential for SOX and Basel II compliance.

Accepted Answer

A) True 
 B)False

Question 8

What is data transformation?

Accepted Answer

Data transformation involves converting

Question 9

Discuss data governance and what needs to be included in a data governance program.

Accepted Answer

Data governance is a set of processes an

Question 10

Joining is often complicated by problems such as errors in source data.

Accepted Answer

A) True 
 B)False

Question 11

User interaction integration is achieved by creating fewer user interfaces.

Accepted Answer

A) True 
 B)False

Question 12

Data reconciliation occurs in two stages,an initial load and subsequent updates.

Accepted Answer

A) True 
 B)False

Question 13

Discuss Master Data Management.

Accepted Answer

Master Data Management refers to the dis

Question 14

External data sources present problems for data quality because:

Accepted Answer

A)  data are not always available. 
B)  there is a lack of control over data quality. 
C)  there are poor data capture controls. 
D)  data are unformatted. 
A)  data are not always available. 
B)  there is a lack of control over data quality. 
C)  there are poor data capture controls. 
D)  data are unformatted.

Question 15

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

Accepted Answer

The answer of The process of transforming data from a...

Question 16

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 17

What are some of the errors and inconsistencies in data that the cleansing process is looking to rectify?

Accepted Answer

There are many errors and inconsistencie

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Question 20

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

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

Retention refers to the amount of data that is not purged periodically from tables.

Informational and operational data differ in all of the following ways EXCEPT:

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

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

One way to improve the data capture process is to:

Data quality is essential for SOX and Basel II compliance.

What is data transformation?

Discuss data governance and what needs to be included in a data governance program.

Joining is often complicated by problems such as errors in source data.

User interaction integration is achieved by creating fewer user interfaces.

Data reconciliation occurs in two stages,an initial load and subsequent updates.

Discuss Master Data Management.

External data sources present problems for data quality because:

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

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

What are some of the errors and inconsistencies in data that the cleansing process is looking to rectify?

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

Conformance means that:

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

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

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

Retention refers to the amount of data that is not purged periodically from tables.

Informational and operational data differ in all of the following ways EXCEPT:

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

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

One way to improve the data capture process is to:

Data quality is essential for SOX and Basel II compliance.

What is data transformation?

Discuss data governance and what needs to be included in a data governance program.

Joining is often complicated by problems such as errors in source data.

User interaction integration is achieved by creating fewer user interfaces.

Data reconciliation occurs in two stages,an initial load and subsequent updates.

Discuss Master Data Management.

External data sources present problems for data quality because:

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

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

What are some of the errors and inconsistencies in data that the cleansing process is looking to rectify?

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

Conformance means that:

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

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