Question 1

Where does Scorecarding fit into the data quality process? Options are :

Options :

A : Not at all - Scorecardlng is a separate process

B : At the start of the process only to assess current data quality levels

C : At the start and during regular intervals of the process to measure on-going data quality levels

D : At the end of the process only to prove the value of the data quality tool

Answer: C

Question 2

What must you do in order to utilize Data Quality accelerators in PowerCenter? Choose 2 answers

Options :

A : Import accelerators directly to Power Center

B : Install accelerators directly to PowerCenter

C : Install accelerators into Developer

D : Export accelerator mapplets and/or mappings to PowerCenter

Answer: B,D

Question 3

When changes are made to a mapplet in IDQ 9.1 that has been integrated into PowerCenter, how are those changes propagated to the integrated mapplet?

Options :

A : Those changes are automatically propagated and managed through domain settings.

B : The user must manually re-export the IDQ mapplet to PowerCenter.

C :

The IDQ versioning system automatically synchs with PowerCenter and updates themapplet to the most current version.

D : None of the above.

Answer: B

Question 4

With respect to field matching in IDQ, which best describes the approach to address matching?

Options :

A : No standardization is necessary, map input fields to the match transformation

B :

Standardize address fields and use address line, locality, region and postcode fields as input to the match transformation

C :

Standardize address fields and use the discrete address component fields, locality, region and postcode fields as input to the match transformation

D :

Standardize address fields, create a group key field which contains parts of the address fields and only use the group key for address matching

Answer: D

Question 5

Users would export DQ mappings to PowerCenter for which of the following reasons? (Choose 4 answers)

Options :

A : Performance

B : Scalability

C : Batch access

D : DQ as part of ETL process

Answer: A,B,C,D