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

You want to derive the gender from a firstname, how would you do this?

A. Use a reference table with the firstname as the valid column and the gender in the second column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

B. Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

C. Use a decision and create an If then else rule eg: If fname = 'Jennifer' then gender: = 'F' Endif

D. Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Custom Strings when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

Which is the best combination of functions to effectively implement a data quality project?

A. Company Executives and IT

B. IT and Business

C. IT and Administration

D. Sales and Marketing

Which is true with regard to Profiles?

A. The Developer can only review Profiles created by the Analyst but can not create any profiles themselves

B. The Developer can take Analyst built profiles with rules and generate a mapping ensuring lossless translation of Information between specification and Implementation.

C. Comments, Tags and Rules can only be applied to profiles in the Analyst Tool

D. Only one Tag can be applied to each object in a project.

When importing a flat file into a project. Developer and Analyst Tool work exactly the same

A. TRUE

B. FALSE

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

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

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

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

IDQ parameters can be defined at what levels? Choose all that apply.

A. Mappings

B. Mapplets

C. Re-usable Transformations

D. Rules

How much data can DQA handle?

A. 2000 rows and 20 columns

B. Million rows and 100 columns

C. There are no built-in restrictions. Large deployments will require more hardware and database tuning

D. Maximum 1 million rows and up to 10,000 columns