INFORMATICA Data Quality 9.x Developer Specialist

1.

Which definition describes Column Profiling?

Colum profiling automatically recognizes all functional and other dependencies in all tables, in particular the primary keys Column profiling is the process of looking at every distinct value to determine the true minimum, maximum, data type, pattern and other important informationabout each attribute Column profiling identifies the attributes for referential integrity Column profiling is the process of creating a normalized schema for your target system

2.

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

Standardization converts data to standardized formats Standardization can remove "noise" Standardization corrects and automatically updates the data in your source system Standardization can remove or replace bad or inconsistent data

3.

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

PC 8.6.1 and higher PC 8.51 and higher All PC versions PC 8.11, PC 8.51 and PC 8.6

4.

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

An xml file containing all the mapping/mapplet/object definition An xml file containing all the mapping/mapplet/object definition and a zip file containing all the reference data if required The contents of each Project (including the dependent reference tables) in a zip file Projects will be exported to an .irob file

5.

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

populations accelerators dictionaries mapplets

6.

Which of these statements is true about Data Rules?

Data Rules must be run against the entire data set they are defined upon Once created a Data Rule cannot be changed...it can only be deleted and re-created A Data Rule created in the Analyst will appear as a mapplet with an Expression Transformation in the Developer Data Rules can only be run on data in the project in which they were created

7.

The IDQ and PowerCenter repositories all share the same schema.

TRUE FALSE

8.

Which of the following will Impact the total amount of time it takes to execute a column profiling process?

Number of Columns in the file Number of Rows in the source data Amount of memory and speed of the processor on the server All of the above

9.

If the inputs to the Edit Distance Strategy below are 'john' and NULL, what will the resultingmatch score be?

0.5 1 1.2

10.

You have just standardized values in a field and you would like to review how the modified dataappears alongside the original data. Which profiling method would best be suited for this?

Column Profiling Mid Stream Profiling Join Analysis Profile Comparative Profiling

INFORMATICA Data Quality 9.x Developer Specialist

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

INFORMATICA Data Quality 9.x Developer Specialist

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner