PR000005 Online Practice Questions and Answers

Which are correct statements for IDQ grouping and matching?Choose 2 answers

A. IDQ field level matching does not utilize grouping

B. When field level matching is performed, the records within each group will be compared against each other

C. When field level matching is performed, matching will be performed across multiple groups in a single match transformation.

D. When field level matching is performed, matching will not be performed across groups, therefore it is imperative grouping is performed on a complete and accurate field(s)

What transformation would you use to standardize data using a reference table?

A. Labeler

B. Decision

C. Standardizer

D. Parser

When importing a flat file into a project. Developer and Analyst Tool work exactly the same

A. TRUE

B. FALSE

Which transformation would you typically use to remove noise, symbols or words?

A. Decision

B. Standardizer

C. Comparison

D. Parser

Users would export DQ mappings to PowerCenter for which of the following reasons? Choose all that apply.

A. Performance

B. Scalability

C. Batch access

D. DQ as part of ETL process

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

A. Standardization converts data to standardized formats

B. Standardization can remove "noise"

C. Standardization corrects and automatically updates the data in your source system

D. Standardization can remove or replace bad or inconsistent data

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

A. populations

B. accelerators

C. dictionaries

D. mapplets

What functionality does Data Quality Assistant provide? Choose 2 answers

A. Consolidate duplicates into master record

B. Bad record management

C. Automatically consolidates data

D. ReGroup records for matching

When is sampling for Profiling a good idea? Select the best answer.

A. When the data set contains sensitive information like credit card numbers.

B. When the probability of data quality issues is small.

C. When the client provides assurances the quality of the data is good.

D. When the volume of data is large and there are storage and/or time constraints.

Which of the following options is TRUE? The Advanced Import Wizard differs from the Basic in that

A. The Advanced method allows conflict resolution and the Basic doesn't.

B. The Advanced Import Wizard allows objects to be imported into multiple target projects / folders and re-factor the dependencies.

C. Import steps can be undone in the Advanced Wizard but not in the Basic one

D. Users have a choice regarding which project objects are imported using Basic and Advanced.