Informatica PR000005 ICP Exam Practice Test Instant Access

Question 1

Where does Scorecarding fit into the data quality process?

ANot at all - Scorecardlng is a separate process

BAt the start of the process only to assess current data quality levels

CAt the start and during regular intervals of the process to measure on-going data quality levels

DAt the end of the process only to prove the value of the data quality tool

Answer : C

Question 2

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 3

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 4

Which Informatica option provides solutions to common data quality issues in a country, region,or industry? Choose 1 answer.

Apopulations

Baccelerators

Cdictionaries

Dmapplets

Answer : C

Question 5

Which transformations can be used in DQ for Excel?

AOnly mappings using a Case Converter and a Standardizer can be used on data in Excel.

BOnly mappings using non active transformations can be used in DQ for Excel.

CAll DQ transformations, including Matching and Consolidation can be used in DQ for Excel.

DAll DQ and Core Transformations can be used in DQ for Excel, there is no limitation.

Answer : D

Question 6

With regard to a Basic Import which of the following is FALSE?

AOnce added, the target will display resolution for each folder imported.

BA conflict resolution can be selected to apply to all imported objects.

CDefault is replace, options include rename or reuse.

DThe import can consist of an XML file and a Zip file containing the reference tables

Answer : C

Question 7

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

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