DATA-QUALITY-10-DEVELOPER-SPECIALIST Online Practice Questions and Answers

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

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.

Which DQ Transformations can be used to automatically consolidate matched records?

A. Consolidation

B. Match and Association

C. Key Gen and Consolidation

D. Key Gen, Association and Consolidation

What versions of PowerCenter can an IDQ 9.1 mapping be exported to?

A. PC 8.6.1 and higher

B. PC 8.51 and higher

C. All PC versions

D. PC 8.11, PC 8.51 and PC 8.6

Which two are index key levels in Identity Matching? Choose 2 answers

A. Narrow

B. Limited

C. Typical

D. Extended

Which transformations can be used in DQ for Excel?

A. Only mappings using a Case Converter and a Standardizer can be used on data in Excel.

B. Only mappings using non active transformations can be used in DQ for Excel.

C. All DQ transformations, including Matching and Consolidation can be used in DQ for Excel.

D. All DQ and Core Transformations can be used in DQ for Excel, there is no limitation.

What happens to the records when corrections are made and a status of Accept is assigned?

A. The corrections are committed to the Staging DB and an UPDATED_STATUS of Accepted is assigned to the record

B. The corrections are committed to the Staging DB and record is automatically pushed into another DB

C. Records are corrected and are sent to an Accepted DB table

D. Records are accepted and are pushed out to Target/Production DB

Where does Scorecarding fit into the data quality process?

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

In the Case Converter transformation which of the following is not a valid Case Transform?

A. Upper Case

B. Lower Case

C. Toggle merge Case

D. Sentence Case

How much data can DQA handle?

A. 2000 rows and 20 columns

B. Million rows and 100 columns

C. There are no built-in restrictions. Large deployments will require more hardware and database tuning

D. Maximum 1 million rows and up to 10,000 columns

What is the primary purpose of grouping data?

A. standardize data in preparation for matching

B. normalize data in preparation for matching

C. Improve match performance

D. improve match results