Informatica PR000005 ICP Exam Questions Instant Access

Question 1

Which of the following is not a function of Data Standardization?

AStandardization converts data to standardized formats

BStandardization can remove 'noise'

CStandardization corrects and automatically updates the data in your source system

DStandardization can remove or replace bad or inconsistent data

Answer : C

Question 2

Which of the following options is TRUE? The Advanced Import Wizard differs from the Basic in that

AThe Advanced method allows conflict resolution and the Basic doesn't.

BThe Advanced Import Wizard allows objects to be imported into multiple target projects / folders and re-factor the dependencies.

CImport steps can be undone in the Advanced Wizard but not in the Basic one

DUsers have a choice regarding which project objects are imported using Basic and Advanced.

Answer : D

http://south.readthedocs.org/en/latest/tutorial/part3.html

Question 3

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

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

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

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

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

Answer : A

Question 4

When using field matching which is the best approach if using First Name as a match field?

ANever use First Name as it is not necessary

BNo standardization of First Name field is necessary

CUse the Edit Distance strategy

DCreate Soundex or NYSIIS value for the First Name and use it in match

Answer : D

Question 5

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

ALocality / City

BElementlnputStatus

CMatch Code

DMSA

Answer : A

Question 6

During a project export, typically what will the output be from the export?

AAn xml file containing all the mapping/mapplet/object definition

BAn xml file containing all the mapping/mapplet/object definition and a zip file containing all the reference data if required

CThe contents of each Project (including the dependent reference tables) in a zip file

DProjects will be exported to an .irob file

Answer : B

Question 7

When is sampling for Profiling a good idea? Select the best answer.

AWhen the data set contains sensitive information like credit card numbers.

BWhen the probability of data quality issues is small.

CWhen the client provides assurances the quality of the data is good.

DWhen the volume of data is large and there are storage and/or time constraints.

Answer : D

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