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

When changes are made to a mapplet in IDQ 9.1 that has been integrated into PowerCenter, howare those changes propagated to the integrated mapplet?

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

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

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

D. None of the above.

Which of the following is stored in the Staging repository?

A. Reference Tables

B. Mappings

C. Reference Tables and Audit information

D. Authentication details

When you select Suggestion List mode what statement is true?

A. The Address Validator transformation searches the address reference data and returns all addresses that are possible matches with the input address.

B. The Address Validator transformation searches the address reference data and returns the most likely candidate address.

C. The Address Validator transformation parses data into the suggested address fields without performing validation.

D. The Address Validator transformation will return various cleansed standardized versions of the input record for the user to choose from.

How is the data loaded into DQA and how is it configured?

A. By running the DQ Client installer

B. The Analyst defines the table in the Analyst tool, and the mappings in the Developer tool create and populate the appropriate tables

C. The Analyst populates and creates the table in the Analyst tool

D. The Administrator needs to create a DQA Service and associate it with the staging database

Which of these statements is true about Data Rules?

A. Data Rules must be run against the entire data set they are defined upon

B. Once created a Data Rule cannot be changed...it can only be deleted and re-created

C. A Data Rule created in the Analyst will appear as a mapplet with an Expression Transformation in the Developer

D. Data Rules can only be run on data in the project in which they were created

What must you do in order to utilize Data Quality accelerators in PowerCenter? Choose 2 answers

A. Import accelerators directly to Power Center

B. Install accelerators directly to PowerCenter

C. Install accelerators into Developer

D. Export accelerator mapplets and/or mappings to PowerCenter

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 file into a database table before profiling.

D. Change the code page of the file to UTF-8.

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