Informatica PR000005 ICP Exam Practice Test Instant Access

Question 1

When applying a reference table in the Labeler in token mode which of the following statements is correct?

AThe order of the reference tables defined will not impact your results displayed

BSelecting Inclusive mode will output items that are present in the reference table under the label provided

CSelecting Exclusive mode will exclude Items that are present in the reference table

DAny items that do not appear in the reference table are not displayed in the output

Answer : B

Question 2

What happens to the records when corrections are made and a status of Accept is assigned?

AThe corrections are committed to the Staging DB and an UPDATED_STATUS of Accepted is assigned to the record

BThe corrections are committed to the Staging DB and record is automatically pushed into another DB

CRecords are corrected and are sent to an Accepted DB table

DRecords are accepted and are pushed out to Target/Production DB

Answer : B

Question 3

What is required for customers to access and use IDQ Accelerator content?

ACustomers must license each Accelerator pack individually to download and use the content.

BNo additional steps are required. All Accelerator content is provided with the basic IDQ license.

CIDQ customers simply need to request an IPS resource to download and install the content.

DAccelerator content is available only with a PowerCenter license.

Answer : B

Question 4

Select the transformation that will not allow a DQ mapplet to validate as a rule in version 9.1.

AExpression Transformation

BAddress Validation Transformation

CAggregator Transformation

DLabeler Transformation

Answer : C

Question 5

You have just standardized values in a field and you would like to review how the modified dataappears alongside the original dat

a. Which profiling method would best be suited for this?

AColumn Profiling

BMid Stream Profiling

CJoin Analysis Profile

DComparative Profiling

Answer : B

Question 6

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 7

IDQ parameters can be defined at what levels? Choose 4 answers

AMappings

BMapplets

CRe-usable Transformations

DRules

Answer : A, B, C, D

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