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.

Accelerators provide which of the following? Choose 4 answers

A. Rules

B. Reference tables

C. Demonstration mappings

D. Demonstration data objects

E. Profiles

The Pattern Parser is used in conjunction with which transformation?

A. Token Parser

B. Standardizer

C. Exception

D. Labeler

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 two IDQ transformations can use parameters? Choose 2 answers

A. Comparison

B. Decision

C. Case converter

D. Address Validation

E. Labeller

Which definition describes Column Profiling?

A. Colum profiling automatically recognizes all functional and other dependencies in all tables, in particular the primary keys

B. Column profiling is the process of looking at every distinct value to determine the true minimum, maximum, data type, pattern and other important information about each attribute

C. Column profiling identifies the attributes for referential integrity

D. Column profiling is the process of creating a normalized schema for your target system

You have just standardized values in a field and you would like to review how the modified dataappears alongside the original data. Which profiling method would best be suited for this?

A. Column Profiling

B. Mid Stream Profiling

C. Join Analysis Profile D. Comparative Profiling

What functionality does Data Quality Assistant provide? Choose 2 answers

A. Consolidate duplicates into master record

B. Bad record management

C. Automatically consolidates data

D. ReGroup records for matching

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