With respect to field matching in IDQ, which best describes the approach to address matching?

A. No standardization is necessary, map input fields to the match transformation

B. Standardize address fields and use address line, locality, region and postcode fields as input to the match transformation

C. Standardize address fields and use the discrete address component fields, locality, region and postcode fields as input to the match transformation

D. Standardize address fields, create a group key field which contains parts of the address fields and only use the group key for address matching

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

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

A. Labeler

B. Decision

C. Standardizer

D. Parser

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

A. Company Executives and IT

B. IT and Business

C. IT and Administration

D. Sales and Marketing

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.

Which of the following statements is true regarding DQ for Excel?

A. DQ for Excel allows .xls files be used as source and target objects in mappings.

B. DQ for Excel enables non Informatica users to benefit from data quality rules by consuming and applying data quality rules directly from MS Excel data/worksheets.

C. DQ for Excel can be used in any version of Excel.

D. In order to be able to use DQ for Excel, both PowerCenter and Data Quality Developer must be installed.

How is Accelerator content installed?

A. Using the IDQ content installer.

B. It is imported through Developer.

C. The file extracted onto the server and it is automatically picked up after restarting the services

D. It is installed using the importer available in the Content Management service

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

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

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

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

Select the item that is not a common symptom of data quality problems.

A. Lack of trust and agreement in reporting

B. high customer satisfaction

C. Supply-chain 'out of stock' situations

D. Failure of IT projects