Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Informatica Data-Quality-10-Developer-Specialist Dumps

Data Quality 10: Developer Specialist Exam Questions and Answers

Question 1

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

Options:

A.

Locality / City

B.

ElementlnputStatus

C.

Match Code

D.

MSA

Question 2

What statement best describes IDQ's Web service capabilities?

Options are :

Options:

A.

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

B.

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

C.

DQ mappings can only be made accessible through native means

D.

DQ has not web service support

Question 3

What transformation would you use to standardize data using a reference table?

Options:

A.

Labeler

B.

Decision

C.

Standardizer

D.

Parser

Question 4

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

Options:

A.

Narrow

B.

Limited

C.

Typical

D.

Extended

Question 5

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

Options are :

Options:

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

Question 6

Which strategy pairs characters together as its match algorithm?

Options:

A.

Edit Distance

B.

Bigram

C.

Hamming Distance

D.

Jaro Distance

Question 7

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

Options:

A.

Company Executives & IT

B.

IT & Business

C.

IT & Administration

D.

Sales & Marketing

Question 8

Should data be standardized before it reaches the Address Validator?

Options:

A.

Yes, street and directional abbreviations should always be expanded to their unabbreviated form.

B.

No, any change may cause problems to the AV transformation.

C.

Yes, if after review, specific problems have been identified that are causing address to not validate that otherwise would.

D.

Yes, they should all be upper case.

Question 9

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

Options are :

Options:

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

Question 10

Which definition describes Column Profiling?

Options are :

Options:

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