Data-Quality-10-Developer-Specialist Exam Training Practice Tests (Informatica Data Quality 10: Developer Specialist)]

Question 1

What functionality does Data Quality Assistant provide? Choose 2 answers Options are :

A. Bad record management B. Automatically consolidates data C. Consolidate duplicates into master record D. ReGroup records for matching

Correct Answer: B,C

Question 2

Which transformations can be used in DQ for Excel?

A. All DQ and Core Transformations can be used in DQ for Excel, there is no limitation. B. All DQ transformations, including Matching and Consolidation can be used in DQ for Excel. C. Only mappings using a Case Converter and a Standardizer can be used on data in Excel. D. Only mappings using non active transformations can be used in DQ for Excel.

Correct Answer: A

Question 3

The Pattern Parser is used in conjunction with which transformation?
Options are :

A. Token Parser B. Labeler C. Exception D. Standardizer

Correct Answer: B

Question 4

A customer wants to be able to review data on the overall quality of each record, which technique should be used?
Options are :

A. Standardization B. Scorecarding C. Grading D. Matching

Correct Answer: A

Question 5

A customer has provided a number of delimited flat files that require profiling, but not file definition. What should you do first?
Options are :

A. Change the code page of the file to UTF-8. B. Set all of the data types to text and length longer than those specified. The profiler will tell you what they should be. C. Allow the wizard in Developer to automatically select the data types when creating the data objects. D. Import the file into a database table before profiling.

Correct Answer: C

Question 6

Which of the following statements is true regarding DQ for Excel?
Options are :

A. DQ for Excel can be used in any version of Excel. B. In order to be able to use DQ for Excel, both PowerCenter and Data Quality Developer must be installed. C. DQ for Excel allows .xls files be used as source and target objects in mappings. D. DQ for Excel enables non Informatica users to benefit from data quality rules by consuming and applying data quality rules directly from MS Excel data/ worksheets.

Correct Answer: D

Question 7

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

A. Canada Post defines the SERP certification standard for software applications that validate Canadian addresses. 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. Remove all punctuation before sending the address to the AV transformation. D. Run the addresses into the AV transformation without modification.

Correct Answer: A

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