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

When using field matching which is the best approach if using First Name as a match field?

A. Never use First Name as it is not necessary

B. No standardization of First Name field is necessary

C. Use the Edit Distance strategy

D. Create Soundex or NYSIIS value for the First Name and use it in match

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 are correct statements for IDQ grouping and matching?Choose 2 answers

A. IDQ field level matching does not utilize grouping

B. When field level matching is performed, the records within each group will be compared against each other

C. When field level matching is performed, matching will be performed across multiple groups in a single match transformation.

D. When field level matching is performed, matching will not be performed across groups, therefore it is imperative grouping is performed on a complete and accurate field(s)

When applying a reference table in the Labeler in token mode which of the following statementsis correct?

A. The order of the reference tables defined will not impact your results displayed

B. Selecting Inclusive mode will output items that are present in the reference table under the label provided

C. Selecting Exclusive mode will exclude Items that are present in the reference table

D. Any items that do not appear in the reference table are not displayed in the output

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 definition describes Column Profiling?

A. Colum profiling automatically recognizes all functional and other dependencies in all tables, in particular the primary keys

B. Column profiling is the process of looking at every distinct value to determine the true minimum, maximum, data type, pattern and other important information about each attribute

C. Column profiling identifies the attributes for referential integrity

D. Column profiling is the process of creating a normalized schema for your target system

What versions of PowerCenter can an IDQ 9.1 mapping be exported to?

A. PC 8.6.1 and higher

B. PC 8.51 and higher

C. All PC versions

D. PC 8.11, PC 8.51 and PC 8.6

When would you use the DQA?

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

Which two are index key levels in Identity Matching? Choose 2 answers

A. Narrow

B. Limited

C. Typical

D. Extended

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.