New Year Sale - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

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

Question # 6

Which definition describes Column Profiling?

Options are :

A.

Column 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

Full Access
Question # 7

With regard to a Basic Import which of the following is FALSE?

A.

Once added, the target will display resolution for each folder imported.

B.

A conflict resolution can be selected to apply to all imported objects.

C.

Default is replace, options include rename or reuse.

D.

The import can consist of an XML file and a Zip file containing the reference tables

Full Access
Question # 8

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

Full Access
Question # 9

Which two IDQ transformations can use parameters? Choose 2 answers

Options are :

A.

Comparison

B.

Decision

C.

Case converter

D.

Address Validation

E.

Labeller

Full Access
Question # 10

What Address Validator output field should you use to determine the quality of addressvalidated?

A.

Locality / City

B.

ElementlnputStatus

C.

Match Code

D.

MSA

Full Access