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

• Question 61:

  Which of the following is stored in the Staging repository?

  A. Reference Tables

  B. Mappings

  C. Reference Tables and Audit information

  D. Authentication details

  Correct Answer: C

  Reference: http://gerardnico.com/doc/powercenter/PC_861_ReferenceTableManager.pdf

• Question 62:

  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.

  Correct Answer: C

• Question 63:

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

  A. 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.

  B. 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.

  C. Use a decision and create an If then else rule eg: If fname = 'Jennifer' then gender: = 'F' Endif

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

• Question 64:

  Where are IDQ mappings saved?

  A. In the location specified in your Source object

  B. In the Staging Database

  C. In the Model Repository

  D. On the Object Explorer tab in the Developer

  Correct Answer: B

• Question 65:

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

  A. No standardization is necessary, map input fields to the match transformation

  B. Standardize address fields and use address line, locality, region and postcode fields as input to the match transformation

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

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

  Correct Answer: B

  Reference: http://scn.sap.com/docs/DOC-30172

• Question 66:

  Which statements describe the Consolidation Transformation?Choose 2 answers

  A. a passive transformation

  B. an active transformation

  C. a transformation which is found only in PowerCenter

  D. creates a single, consolidated record from records identified as possible duplicates by the Match transformation

  Correct Answer: BD

• Question 67:

  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

  Correct Answer: D

• Question 68:

  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.

  Correct Answer: B

• Question 69:

  What Address Validator output field should you use to determine the quality of addressvalidated?

  A. Locality / City

  B. ElementlnputStatus

  C. Match Code

  D. MSA

  Correct Answer: A

• Question 70:

  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

  Correct Answer: C