Labour Day Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Informatica Data-Quality-10-Developer-Specialist Data Quality 10: Developer Specialist Exam Exam Practice Test

Page: 1 / 7
Total 70 questions

Data Quality 10: Developer Specialist Exam Questions and Answers

Question 1

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 2

Users would export DQ mappings to PowerCenter for which of the following reasons? (Choose 4 answers)

Options:

A.

Performance

B.

Scalability

C.

Batch access

D.

DQ as part of ETL process

Question 3

When is sampling for Profiling a good idea? Select the best answer.

Options:

A.

When the data set contains sensitive information like credit card numbers.

B.

When the probability of data quality issues is small.

C.

When the client provides assurances the quality of the data is good.

D.

When the volume of data is large and there are storage and/or time constraints.

Question 4

A customer wants to be able to review data on the overall quality of each record, which technique should be used?

Options are :

Options:

A.

Scorecarding

B.

Matching

C.

Grading

D.

Standardization

Question 5

When matching, is it always necessary to group data?

Options are :

Options:

A.

Only if the customer thinks it's a good idea

B.

Only if the quality of the data is poor

C.

Not always. If the dataset is small enough, grouping is not required

D.

Yes, it's always necessary

Question 6

During a project export, typically what will the output be from the export?

Options are :

Options:

A.

An xml file containing all the mapping/mapplet/object definition

B.

An xml file containing all the mapping/mapplet/object definition and a zip file containing all the reference data if required

C.

The contents of each Project (including the dependent reference tables) in a zip file

D.

Projects will be exported to an .irob file

Question 7

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 8

What is the best approach to implementing Address Validation in version 9.1?

Options are :

Options:

A.

Run the addresses into the AV transformation without modification.

B.

Take an iterative approach and review AV output. Determine why addresses did not validate and attempt to resolve the issue prior to running them in the AV transformation.

C.

Canada Post defines the SERP certification standard for software applications that validate Canadian addresses.

D.

Remove all punctuation before sending the address to the AV transformation.

Question 9

How is the data loaded into DQA and how is it configured?

Options:

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

Question 10

What happens to the records when corrections are made and a status of Accept is assigned?

Options are :

Options:

A.

The corrections are committed to the Staging DB and an UPDATED_STATUS of Accepted is assigned to the record

B.

The corrections are committed to the Staging DB and record is automatically pushed into another DB

C.

Records are corrected and are sent to an Accepted DB table

D.

Records are accepted and are pushed out to Target/Production DB

Page: 1 / 7
Total 70 questions