DATA-QUALITY-10-DEVELOPER-SPECIALIST Online Practice Questions and Answers

With regard to a Basic Import which of the following is FALSE?

A. Once added, the target will display resolution for each folder imported.

B. A conflict resolution can be selected to apply to all imported objects.

C. Default is replace, options include rename or reuse.

D. The import can consist of an XML file and a Zip file containing the reference tables

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

A. Labeler

B. Decision

C. Standardizer

D. Parser

Which DQ Transformations can be used to automatically consolidate matched records?

A. Consolidation

B. Match and Association

C. Key Gen and Consolidation

D. Key Gen, Association and Consolidation

The IDQ and PowerCenter repositories all share the same schema.

A. TRUE

B. FALSE

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?

A. Column Profiling

B. Mid Stream Profiling

C. Join Analysis Profile D. Comparative Profiling

Which of the following is NOT a required step for using DQ for Excel?

A. In Excel, choose to Add a service and either enter the URL address or select the .wsdl or .xml file to be imported.

B. Build and Test a web Services Mapping in the Developer Tool.

C. Export the Mapping to PowerCenter and test.

D. Create and Deploy the mapping as an Application.

Select the transformation that will not allow a DQ mapplet to validate as a rule in version 9.1.

A. Expression Transformation

B. Address Validation Transformation

C. Aggregator Transformation

D. Labeler Transformation

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.

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

What Data Quality Transformation utilizes Identity populations?

A. Key Generator Transformation

B. Match Transformation

C. Edit Distance Transformation

D. Comparison Transformation