Informatica pr000005 practice test

Question 1

What Data Quality Transformation utilizes Identity populations?

• A. Key Generator Transformation
• B. Match Transformation
• C. Edit Distance Transformation
• D. Comparison Transformation

Answer:

C

Question 2

Which phrase best describes how organizations should view their approach to data quality?

• A. As a one-off project addressing the issues in their data warehouse in batch
• B. As an ongoing process addressing issues over time with a combination of fit-for-purpose approaches
• C. As a real-time process addressing issues as they are introduced
• D. As a batch process to be implemented to run on a monthly basis

Answer:

A

Explanation:
Reference:
http://dssresources.com/papers/features/langseth/langseth02082004.html

Question 3

Which of the following cannot be executed in BOTH the Analyst and the Developer Tool?

• A. A rule created in the Analyst Tool
• B. A mapplet created in the Developer Tool and validated as a rule
• C. A mapplet created in the Developer Tool and validated as a mapplet
• D. A reusable rule created in the Analyst Tool

Answer:

B

Question 4

What is the primary purpose of grouping data?

• A. standardize data in preparation for matching
• B. normalize data in preparation for matching
• C. Improve match performance
• D. improve match results

Answer:

C

Question 5

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

• A. Customers must license each Accelerator pack individually to download and use the content.
• B. No additional steps are required. All Accelerator content is provided with the basic IDQ license.
• C. IDQ customers simply need to request an IPS resource to download and install the content.
• D. Accelerator content is available only with a PowerCenter license.

Answer:

B

Question 6

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

• A. Allow the wizard in Developer to automatically select the data types when creating the data objects.
• B. Set all of the data types to text and length longer than those specified. The profiler will tell you what they should be.
• C. Import the fileinto a database table before profiling.
• D. Change the code page of the file to UTF-8.

Answer:

A

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

Question 7

Which parameter function is supported in IDQ 9.1?

• A. Set parameter for RTM Location/ Path
• B. Set parameter for RTM Name
• C. Ability to parameterise relational and flat-file connections
• D. All of the above

Answer:

D

Question 8

How much data can DQA handle?

• A. 2000 rows and 20 columns
• B. Million rows and 100 columns
• C. There are no built-in restrictions. Large deployments will require more hardware and database tuning
• D. Maximum 1 million rows and up to 10,000 columns

Answer:

B

Question 9

What statement best describes IDQ's Web service capabilities?

• A. Mappings can only be created as a web service through PC integration
• B. DQ has both native web service functionality and allows integration through PC
• C. DQ mappings can only be made accessible through native means
• D. DQ has not web service support

Answer:

C

Question 10

When matching, is it always necessary to group data?

• A. Only if the customer thinks it's a good idea
• B. Only if the quality of the data is poor
• C. Not always. If the dataset is small enough, grouping is not required
• D. Yes, it's always necessary

Answer:

C