Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

examout.co

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

Options are :

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

Which statements describe the Consolidation Transformation? (Choose 2 answers)

A.

a passive transformation

B.

an active transformation

C.

a transformation which is found only in PowerCenter

D.

creates a single, consolidated record from records identified as possible duplicates by the Match transformation

Which are correct statements for IDQ grouping and matching? (Choose 2 answers)

A.

IDQ field level matching does not utilize grouping

B.

When field level matching is performed, the records within each group will be compared against each other

C.

When field level matching is performed, matching will be performed across multiple groups in a single match transformation.

D.

When field level matching is performed, matching will not be performed across groups, therefore it is imperative grouping is performed on a complete and accurate field(s)

Where are IDQ mappings saved?

A.

In the location specified in your Source object

B.

In the Staging Database

C.

In the Model Repository

D.

On the Object Explorer tab in the Developer

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

Options are :

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

If the inputs to the Edit Distance Strategy below are 'john' and NULL, what will the resulting match score be?

Larger image

Options are :

A.

0

B.

0.5

C.

1

D.

1.2

When you select Suggestion List mode what statement is true?

A.

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

B.

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

C.

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

D.

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

Where does Scorecarding fit into the data quality process?

Options are :

A.

Not at all - Scorecardlng is a separate process

B.

At the start of the process only to assess current data quality levels

C.

At the start and during regular intervals of the process to measure on-going data quality levels

D.

At the end of the process only to prove the value of the data quality tool

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

A.

Company Executives & IT

B.

IT & Business

C.

IT & Administration

D.

Sales & Marketing

Which of the following will Impact the total amount of time it takes to execute a column profiling process?

Options are :

A.

Number of Columns in the file

B.

Number of Rows in the source data

C.

Amount of memory and speed of the processor on the server

D.

All of the above