Question 1

User interaction integration is achieved by creating fewer user interfaces.

Accepted Answer

A) True 
 B)False

Question 2

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 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

Discuss Master Data Management.

Accepted Answer

Master Data Management refers to the dis...

Question 6

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 7

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.E) A) and C)
F) B) and D)

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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.E) B) and C)
F) C) and D)

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

Data quality is essential for SOX and Basel II compliance.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

What is data transformation?

Accepted Answer

Data transformation involves converting ...

Question 16

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.E) C) and D)
F) B) and C)

Question 17

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.E) C) and D)
F) All of the above

Question 18

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 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.E) None of the above
F) C) and D)

Question 20

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.E) None of the above
F) A) and B)

Exam 10: Data Quality and Integration

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

Correct AnswerverifiedShow Answer

Data quality is essential for SOX and Basel II compliance.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedThere are many errors and inconsistencie...View AnswerShow Answer

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

Correct AnswerverifiedData governance is a set of processes an...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

One way to improve the data capture process is to:

Correct AnswerverifiedShow Answer

Conformance means that:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

External data sources present problems for data quality because:

Correct AnswerverifiedShow Answer

User interaction integration is achieved by creating fewer user interfaces.

Correct AnswerverifiedShow Answer

What is data transformation?

Correct AnswerverifiedData transformation involves converting ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedRefresh mode is an approach to filling a...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Discuss Master Data Management.

Correct AnswerverifiedMaster Data Management refers to the dis...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
There are many errors and inconsistencie...
View Answer

Correct Answer
verified
Data governance is a set of processes an...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Data transformation involves converting ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Refresh mode is an approach to filling a...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Master Data Management refers to the dis...
View Answer

Correct Answer
verified