PR000005 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.

What types of profiling can be performed in the Developer Tool in Data Quality?

A. Column Profiling, Primary Key Inference, Dependency Inference

B. Column and Join Profiling only

C. Column, Join Analysis, Mid Stream and Comparative Profiling

D. Column, Join Analysis, Mid Stream, Comparative, Primary and Foreign Key and Overlap Profiling

Which of the following is not true when it comes to creating and updating Reference Tables?

A. Reference Tables can be updated from a Value Frequency list in the Developer

B. All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst

C. Reference Tables maintained in the Analyst and Developer tools are stored in separate repositories

D. Reference Tables can be imported and exported using the Developer Tool

Which two of the following values can be parameterized in the Match transformation? Choose 2 answers

A. Threshold values

B. Scoring methods

C. Match Field Inputs

D. Weights

How is the data loaded into DQA and how is it configured?

A. By running the DQ Client installer

B. The Analyst defines the table in the Analyst tool, and the mappings in the Developer tool create and populate the appropriate tables

C. The Analyst populates and creates the table in the Analyst tool

D. The Administrator needs to create a DQA Service and associate it with the staging database

Which two IDQ transformations can use parameters? Choose 2 answers

A. Comparison

B. Decision

C. Case converter

D. Address Validation

E. Labeller

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

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

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.

Which parameter function is supported in IDQ 9.1?

A. Set parameter for RTM Location/ Path

B. Set parameter for RTM Name

C. Ability to parameterise relational and flat-file connections

D. All of the above

Which of the following cannot be executed in BOTH the Analyst and the Developer Tool?

A. A rule created in the Analyst Tool

B. A mapplet created in the Developer Tool and validated as a rule

C. A mapplet created in the Developer Tool and validated as a mapplet

D. A reusable rule created in the Analyst Tool