Informatica PR000005 ICP Exam Questions Instant Access

Question 1

Users would export DQ mappings to PowerCenter for which of the following reasons? Choose 4 answers

APerformance

BScalability

CBatch access

DDQ as part of ETL process

Answer : A, B, C, D

Question 2

Which of the following is stored in the Staging repository?

AReference Tables

BMappings

CReference Tables and Audit information

DAuthentication details

Answer : C

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

Question 3

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

ADQ for Excel allows .xls files be used as source and target objects in mappings.

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

CDQ for Excel can be used in any version of Excel.

DIn order to be able to use DQ for Excel, both PowerCenter and Data Quality Developer must be installed.

Answer : B

https://community.informatica.com/solutions/data_quality_microsoft_excel

Question 4

What is the primary purpose of grouping data?

Astandardize data in preparation for matching

Bnormalize data in preparation for matching

CImprove match performance

Dimprove match results

Answer : C

Question 5

Should data be standardized before it reaches the Address Validator?

AYes, street and directional abbreviations should always be expanded to their unabbreviated form.

BNo, any change may cause problems to the AV transformation.

CYes, if after review, specific problems have been identified that are causing address to not validate that otherwise would.

DYes, they should all be upper case.

Answer : A

Question 6

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

Answer : B

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

Question 7

Which strategy pairs characters together as its match algorithm?

AEdit Distance

BBigram

CHamming Distance

DJaro Distance

Answer : C

Informatica Data Quality 9.x Developer Specialist PR000005 ICP Exam Questions