PR000005 Online Practice Questions and Answers

With regard to a Basic Import which of the following is FALSE?

A. Once added, the target will display resolution for each folder imported.

B. A conflict resolution can be selected to apply to all imported objects.

C. Default is replace, options include rename or reuse.

D. The import can consist of an XML file and a Zip file containing the reference tables

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.

When using field matching which is the best approach if using First Name as a match field?

A. Never use First Name as it is not necessary

B. No standardization of First Name field is necessary

C. Use the Edit Distance strategy

D. Create Soundex or NYSIIS value for the First Name and use it in match

When sharing Projects across teams which of the following is True?

A. The same icon is used to indicate a shared and non shared project.

B. Comments that are added to a profile in the Analyst can be viewed by the Developer in the same profile in the Developer Tool.

C. Permissions need to be assigned to each Folder within the project so users of shared projects can access all the objects.

D. Rules that were created In the Analyst Tool will be visible In the Developer but Developer built rules can not be made available in the Analyst.

When importing a flat file into a project. Developer and Analyst Tool work exactly the same

A. TRUE

B. FALSE

When applying a reference table in the Labeler in token mode which of the following statementsis correct?

A. The order of the reference tables defined will not impact your results displayed

B. Selecting Inclusive mode will output items that are present in the reference table under the label provided

C. Selecting Exclusive mode will exclude Items that are present in the reference table

D. Any items that do not appear in the reference table are not displayed in the output

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 Informatica option provides solutions to common data quality issues in a country, region,or industry? Choose 1 answer.

A. populations

B. accelerators

C. dictionaries

D. mapplets

If the inputs to the Edit Distance Strategy below are 'john' and NULL, what will the resultingmatch score be?

A. 0

B. 0.5

C. 1

D. 1.2

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