Which of the following is stored in the Staging repository?

A. Reference Tables

B. Mappings

C. Reference Tables and Audit information

D. Authentication details

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

A. Decision

B. Standardizer

C. Comparison

D. Parser

When profiling, why is it good to sort the value lists in both ascending and descending order?

A. There is no specific reason. It is simply a step of an ordered best practice approach.

B. It is good because it is easier to determine if a field is numeric or text.

C. Values with leading spaces or punctuation will typically sort to the top or bottom making them easier to identify.

D. None of the above.

Which two of the following values can be parameterized in the Match transformation? Choose 2 answers

A. Threshold values

B. Scoring methods

C. Match Field Inputs

D. Weights

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

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

If the inputs to the Edit Distance Strategy below are 'john' and NULL, what will the resultingmatch score be?

A. 0

B. 0.5

C. 1

D. 1.2

What happens to the records when corrections are made and a status of Accept is assigned?

A. The corrections are committed to the Staging DB and an UPDATED_STATUS of Accepted is assigned to the record

B. The corrections are committed to the Staging DB and record is automatically pushed into another DB

C. Records are corrected and are sent to an Accepted DB table

D. Records are accepted and are pushed out to Target/Production DB

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