Informatica PR000005 ICP Exam Practice Test Instant Access

Question 1

When you select Suggestion List mode what statement is true?

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

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

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

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

Answer : A

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

Question 2

Which DQ Transformations can be used to automatically consolidate matched records?

AConsolidation

BMatch and Association

CKey Gen and Consolidation

DKey Gen, Association and Consolidation

Answer : B

http://www.infoflow.co.za/pdfs/Informatica%20Data%20Quality%20Developer%209x%20Training %20Data%20Sheet.pdf

Question 3

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

AColumn Profiling, Primary Key Inference, Dependency Inference

BColumn and Join Profiling only

CColumn, Join Analysis, Mid Stream and Comparative Profiling

DColumn, Join Analysis, Mid Stream, Comparative, Primary and Foreign Key and Overlap Profiling

Answer : C

Question 4

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 5

A customer has provided a number of delimited flat files that require profiling, but not filedefinition. What should you do first?

AAllow the wizard in Developer to automatically select the data types when creating the data objects.

BSet all of the data types to text and length longer than those specified. The profiler will tell you what they should be.

CImport the fileinto a database table before profiling.

DChange the code page of the file to UTF-8.

Answer : A

http://in.mathworks.com/help/simulink/ug/working-with-data-objects.html

Question 6

Which of the following is NOT a required step for using DQ for Excel?

AIn Excel, choose to Add a service and either enter the URL address or select the .wsdl or .xml file to be imported.

BBuild and Test a web Services Mapping in the Developer Tool.

CExport the Mapping to PowerCenter and test.

DCreate and Deploy the mapping as an Application.

Answer : A

Question 7

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

ALabeler

BDecision

CStandardizer

DParser

Answer : D

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

Informatica PR000005 Data Quality 9.x Developer Specialist ICP Exam Practice Test