Informatica PR000005 Quiz 6 Topic 7 Questions 26-30

Question: 1

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

AReference Tables can be updated from a Value Frequency list in the Developer

BAll except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst

CReference Tables maintained in the Analyst and Developer tools are stored in separate repositories

DReference Tables can be imported and exported using the Developer Tool

Show Answer

Question: 2

Which statements describe the Consolidation Transformation?Choose 2 answers

Aa passive transformation

Ban active transformation

Ca transformation which is found only in PowerCenter

Dcreates a single, consolidated record from records identified as possible duplicates by the Match transformation

Show Answer

Question: 3

With respect to field matching in IDQ, which best describes the approach to address matching?

ANo standardization is necessary, map input fields to the match transformation

BStandardize address fields and use address line, locality, region and postcode fields as input to the match transformation

CStandardize address fields and use the discrete address component fields, locality, region and postcode fields as input to the match transformation

DStandardize address fields, create a group key field which contains parts of the address fields and only use the group key for address matching

Show Answer

Question: 4

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

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

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

CImport steps can be undone in the Advanced Wizard but not in the Basic one

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

Show Answer

Question: 5

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

AColumn Profiling, Primary Key Inference, Dependency Inference

BColumn and Join Profiling only

CColumn, Join Analysis, Mid Stream and Comparative Profiling

DColumn, Join Analysis, Mid Stream, Comparative, Primary and Foreign Key and Overlap Profiling

Show Answer

Informatica PR000005 Quiz:6 Topic:7 Questions:26-30