Informatica Informatica Certifications DATA-QUALITY-10-DEVELOPER-SPECIALIST Questions & Answers

• Question 51:

  Accelerators provide which of the following? Choose 4 answers

  A. Rules

  B. Reference tables

  C. Demonstration mappings

  D. Demonstration data objects

  E. Profiles

  Correct Answer: ACDE

• Question 52:

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

  A. TRUE

  B. FALSE

  Correct Answer: A

• Question 53:

  Which transformation would you typically use to remove noise, symbols or words?

  A. Decision

  B. Standardizer

  C. Comparison

  D. Parser

  Correct Answer: B

• Question 54:

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

  A. Column Profiling, Primary Key Inference, Dependency Inference

  B. Column and Join Profiling only

  C. Column, Join Analysis, Mid Stream and Comparative Profiling

  D. Column, Join Analysis, Mid Stream, Comparative, Primary and Foreign Key and Overlap Profiling

  Correct Answer: C

• Question 55:

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

  A. Scorecarding

  B. Matching

  C. Grading

  D. Standardization

  Correct Answer: D

• Question 56:

  Which is true with regard to Profiles?

  A. The Developer can only review Profiles created by the Analyst but can not create any profiles themselves

  B. The Developer can take Analyst built profiles with rules and generate a mapping ensuring lossless translation of Information between specification and Implementation.

  C. Comments, Tags and Rules can only be applied to profiles in the Analyst Tool

  D. Only one Tag can be applied to each object in a project.

  Correct Answer: C

• Question 57:

  Which is the best combination of functions to effectively implement a data quality project?

  A. Company Executives and IT

  B. IT and Business

  C. IT and Administration

  D. Sales and Marketing

  Correct Answer: A

  Reference: http://www2.sas.com/proceedings/sugi29/098-29.pdf

• Question 58:

  When you select Suggestion List mode what statement is true?

  A. The Address Validator transformation searches the address reference data and returns all addresses that are possible matches with the input address.

  B. The Address Validator transformation searches the address reference data and returns the most likely candidate address.

  C. The Address Validator transformation parses data into the suggested address fields without performing validation.

  D. The Address Validator transformation will return various cleansed standardized versions of the input record for the user to choose from.

  Correct Answer: A

  Reference: https://community.informatica.com/mpresources/docs/Readme_2850.pdf

• Question 59:

  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: AD

  Reference:

  https://community.informatica.com/servlet/JiveServlet/previewBody/2660-102-5-5041/DQ %20Developer%

  209x%20Specialist%20Skill%20Set%20Inventory.pdf

• Question 60:

  What transformation would you use to standardize data using a reference table?

  A. Labeler

  B. Decision

  C. Standardizer

  D. Parser

  Correct Answer: D

  Reference: https://communities.sas.com/docs/DOC-9873