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

Column profiling automatically recognizes all functional and other dependencies in all tables, in particular the primary keys

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

Column profiling identifies the attributes for referential integrity

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

Mappings can only be created as a web service through PC integration

DQ has both native web service functionality and allows integration through PC

DQ mappings can only be made accessible through native means

DQ has not web service support

Comparison

Decision

Case converter

Address Validation

Labeller

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

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

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

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

The same icon is used to indicate a shared and non shared project.

Comments that are added to a profile in the Analyst can be viewed by the Developer in the same profile in the Developer Tool.

Permissions need to be assigned to each Folder within the project so users of shared projects can access all the objects.

Rules that were created In the Analyst Tool will be visible In the Developer but Developer built rules can not be made available in the Analyst.

standardize data in preparation for matching

normalize data in preparation for matching

Improve match performance

improve match results

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

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

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

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