Data-Quality-10-Developer-Specialist by Informatica Valid Free Exam Practice Test

Question 1

Which are correct statements for IDQ grouping and matching? (Choose 2 answers)

A. IDQ field level matching does not utilize grouping B. When field level matching is performed, the records within each group will be compared against each other C. When field level matching is performed, matching will be performed across multiple groups in a single match transformation. D. When field level matching is performed, matching will not be performed across groups, therefore it is imperative grouping is performed on a complete and accurate field(s)

Correct Answer: A,D

Question 2

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

A. All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst B. Reference Tables maintained in the Analyst and Developer tools are stored in separate repositories C. Reference Tables can be updated from a Value Frequency list in the Developer D. Reference Tables can be imported and exported using the Developer Tool

Correct Answer: A

Question 3

Accelerators provide which of the following? Choose 4 answers
Options are :

A. Demonstration mappings B. Profiles C. Reference tables D. Rules E. Demonstration data objects

Correct Answer: A,B,D,E

Question 4

Which statements describe the Consolidation Transformation? (Choose 2 answers)

A. an active transformation B. creates a single, consolidated record from records identified as possible duplicates by the Match transformation C. a transformation which is found only in PowerCenter D. a passive transformation

Correct Answer: A,B

Question 5

Which of the following will not work when adding transformations to mappings?
Options are :

A. Click and drag the transformation onto the mapping B. Double click on the transformation in the transformation palette C. Right click and choose Add Transformation on the mapping D. From the Mapping menu, select Add Transformation

Correct Answer: A

Question 6

Which DQ Transformations can be used to automatically consolidate matched records?

A. Key Gen and Consolidation B. Consolidation C. Match and Association D. Key Gen, Association and Consolidation

Correct Answer: C

Question 7

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

A. 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. B. Use a decision and create an If then else rule eg: If fname = 'Jennifer' then gender: = 'F' Endif C. 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. 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.

Correct Answer: C

Informatica Data Quality 10: Developer Specialist - Data-Quality-10-Developer-Specialist Exam Practice Test