Informatica PR000005 ICP Exam Practice Test Instant Access

Question 1

In version 9.1, what does the Content Management Service do?

AIt manages the dictionaries created in the Analyst Tool.

BIt provides the DIS with information on the location of the address validation data as well as license and other AV configuration settings.

CIt runs Identity Matching

DIt makes the Profile repository available to outside reporting applications like Jaspersoft.

Answer : B

Question 2

What versions of PowerCenter can an IDQ 9.1 mapping be exported to?

APC 8.6.1 and higher

BPC 8.51 and higher

CAll PC versions

DPC 8.11, PC 8.51 and PC 8.6

Answer : D

Question 3

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 4

When matching, is it always necessary to group data?

AOnly if the customer thinks it's a good idea

BOnly if the quality of the data is poor

CNot always. If the dataset is small enough, grouping is not required

DYes, it's always necessary

Answer : C

Question 5

Which definition describes Column Profiling?

AColum profiling automatically recognizes all functional and other dependencies in all tables, in particular the primary keys

BColumn profiling is the process of looking at every distinct value to determine the true minimum, maximum, data type, pattern and other important information about each attribute

CColumn profiling identifies the attributes for referential integrity

DColumn profiling is the process of creating a normalized schema for your target system

Answer : D

http://h21007.www2.hp.com/portal/download/product/19134/infa_DE__6709_web_1216332160371.pdf

Question 6

Which of these statements is true about Data Rules?

AData Rules must be run against the entire data set they are defined upon

BOnce created a Data Rule cannot be changed...it can only be deleted and re-created

CA Data Rule created in the Analyst will appear as a mapplet with an Expression Transformation in the Developer

DData Rules can only be run on data in the project in which they were created

Answer : D

http://docs.oracle.com/cd/B31080_01/doc/owb.102/b28223/concept_data_quality.htm

Question 7

The Pattern Parser is used in conjunction with which transformation?

AToken Parser

BStandardizer

CException

DLabeler

Answer : D

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