Data-Quality-10-Developer-Specialist Practice Exam Questions and Answers

A.  

Not at all - Scorecardlng is a separate process

B.  

At the start of the process only to assess current data quality levels

C.  

At the start and during regular intervals of the process to measure on-going data quality levels

D.  

At the end of the process only to prove the value of the data quality tool

A.  

On suspect/exception records that fall out of a profile, standardization or matching process in IDQ

B.  

On records that could not be matched in a matching mapping

C.  

On records that are output from the Consolidation transformation

D.  

On records that are output from the Association transformation

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

A.  

Reference Tables

B.  

Mappings

C.  

Reference Tables and Audit information

D.  

Authentication details

A.  

Number of Columns in the file

B.  

Number of Rows in the source data

C.  

Amount of memory and speed of the processor on the server

D.  

All of the above

A.  

Decision

B.  

Standardizer

C.  

Comparison

D.  

Parser

A.  

Double click on the transformation in the transformation palette

B.  

Click and drag the transformation onto the mapping

C.  

From the Mapping menu, select Add Transformation

D.  

Right click and choose Add Transformation on the mapping

A.  

Only if the customer thinks it's a good idea

B.  

Only if the quality of the data is poor

C.  

Not always. If the dataset is small enough, grouping is not required

D.  

Yes, it's always necessary

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.

A.  

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

B.  

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

C.  

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

D.  

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