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 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

What types of profiling can be performed in the Developer Tool in Data Quality?

A. Column Profiling, Primary Key Inference, Dependency Inference

B. Column and Join Profiling only

C. Column, Join Analysis, Mid Stream and Comparative Profiling

D. Column, Join Analysis, Mid Stream, Comparative, Primary and Foreign Key and Overlap Profiling

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.

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

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

The Pattern Parser is used in conjunction with which transformation?

A. Token Parser

B. Standardizer

C. Exception

D. Labeler

Should data be standardized before it reaches the Address Validator?

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.

The IDQ and PowerCenter repositories all share the same schema.

A. TRUE

B. FALSE

Which of the following is NOT a required step for using DQ for Excel?

A. In Excel, choose to Add a service and either enter the URL address or select the .wsdl or .xml file to be imported.

B. Build and Test a web Services Mapping in the Developer Tool.

C. Export the Mapping to PowerCenter and test.

D. Create and Deploy the mapping as an Application.

How much data can DQA handle?

A. 2000 rows and 20 columns

B. Million rows and 100 columns

C. There are no built-in restrictions. Large deployments will require more hardware and database tuning

D. Maximum 1 million rows and up to 10,000 columns