PR000005 Online Practice Questions and Answers

Which statements describe the Consolidation Transformation?Choose 2 answers

A. a passive transformation

B. an active transformation

C. a transformation which is found only in PowerCenter

D. creates a single, consolidated record from records identified as possible duplicates by the Match transformation

You want to derive the gender from a firstname, how would you do this?

A. Use a reference table with the firstname as the valid column and the gender in the second column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

B. Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

C. Use a decision and create an If then else rule eg: If fname = 'Jennifer' then gender: = 'F' Endif

D. Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Custom Strings when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

Accelerators provide which of the following? Choose 4 answers

A. Rules

B. Reference tables

C. Demonstration mappings

D. Demonstration data objects

E. Profiles

What is the best approach to implementing Address Validation in version 9.1?

A. Run the addresses into the AV transformation without modification.

B. Take an iterative approach and review AV output. Determine why addresses did not validate and attempt to resolve the issue prior to running them in the AV transformation.

C. Canada Post defines the SERP certification standard for software applications that validate Canadian addresses.

D. Remove all punctuation before sending the address to the AV transformation.

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

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

Which of the following options is TRUE? The Advanced Import Wizard differs from the Basic in that

A. The Advanced method allows conflict resolution and the Basic doesn't.

B. The Advanced Import Wizard allows objects to be imported into multiple target projects / folders and re-factor the dependencies.

C. Import steps can be undone in the Advanced Wizard but not in the Basic one

D. Users have a choice regarding which project objects are imported using Basic and Advanced.

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

What is required for customers to access and use IDQ Accelerator content?

A. Customers must license each Accelerator pack individually to download and use the content.

B. No additional steps are required. All Accelerator content is provided with the basic IDQ license.

C. IDQ customers simply need to request an IPS resource to download and install the content.

D. Accelerator content is available only with a PowerCenter license.