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

A. The user must manually re-export the IDQ mapplet to PowerCenter.

B. The IDQ versioning system automatically synchs with PowerCenter and updates themapplet to the most current version.

C. Those changes are automatically propagated and managed through domain settings.

D. None of the above.

A. Maximum 1 million rows and up to 10,000 columns

B. 2000 rows and 20 columns

C. There are no built-in restrictions. Large deployments will require more hardware and database tuning

D. Million rows and 100 columns

A. Standardization converts data to standardized formats

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

C. Standardization can remove "noise"

D. Standardization can remove or replace bad or inconsistent data

A. All DQ and Core Transformations can be used in DQ for Excel, there is no limitation.

B. Only mappings using non active transformations can be used in DQ for Excel.

C. All DQ transformations, including Matching and Consolidation can be used in DQ for Excel.

D. Only mappings using a Case Converter and a Standardizer can be used on data in Excel.

A. As a real-time process addressing issues as they are introduced

B. As a one-off project addressing the issues in their data warehouse in batch

C. As an ongoing process addressing issues over time with a combination of fit-for-purpose approaches

D. As a batch process to be implemented to run on a monthly basis

A. DQ has not web service support

B. Mappings can only be created as a web service through PC integration

C. DQ mappings can only be made accessible through native means

D. DQ has both native web service functionality and allows integration through PC

A. Rules

B. Mappings

C. Mapplets

D. Re-usable Transformations