PR000005 Online Practice Questions and Answers

When changes are made to a mapplet in IDQ 9.1 that has been integrated into PowerCenter, howare those changes propagated to the integrated mapplet?

A. Those changes are automatically propagated and managed through domain settings.

B. The user must manually re-export the IDQ mapplet to PowerCenter.

C. The IDQ versioning system automatically synchs with PowerCenter and updates themapplet to the most current version.

D. None of the above.

When sharing Projects across teams which of the following is True?

A. The same icon is used to indicate a shared and non shared project.

B. Comments that are added to a profile in the Analyst can be viewed by the Developer in the same profile in the Developer Tool.

C. Permissions need to be assigned to each Folder within the project so users of shared projects can access all the objects.

D. Rules that were created In the Analyst Tool will be visible In the Developer but Developer built rules can not be made available in the Analyst.

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

A. Labeler

B. Decision

C. Standardizer

D. Parser

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 is true with regard to Profiles?

A. The Developer can only review Profiles created by the Analyst but can not create any profiles themselves

B. The Developer can take Analyst built profiles with rules and generate a mapping ensuring lossless translation of Information between specification and Implementation.

C. Comments, Tags and Rules can only be applied to profiles in the Analyst Tool

D. Only one Tag can be applied to each object in a project.

Which transformation would you typically use to remove noise, symbols or words?

A. Decision

B. Standardizer

C. Comparison

D. Parser

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.

Which two of the following values can be parameterized in the Match transformation? Choose 2 answers

A. Threshold values

B. Scoring methods

C. Match Field Inputs

D. Weights

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.

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

In version 9.1, what does the Content Management Service do?

A. It manages the dictionaries created in the Analyst Tool.

B. It provides the DIS with information on the location of the address validation data as well as license and other AV configuration settings.

C. It runs Identity Matching

D. It makes the Profile repository available to outside reporting applications like Jaspersoft.

Select the transformation that will not allow a DQ mapplet to validate as a rule in version 9.1.

A. Expression Transformation

B. Address Validation Transformation

C. Aggregator Transformation

D. Labeler Transformation

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

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

In the Case Converter transformation which of the following is not a valid Case Transform?

A. Upper Case

B. Lower Case

C. Toggle merge Case

D. Sentence Case

What is required for customers to access and use IDQ Accelerator content?

A. Customers must license each Accelerator pack individually to download and use the content.

B. No additional steps are required. All Accelerator content is provided with the basic IDQ license.

C. IDQ customers simply need to request an IPS resource to download and install the content.

D. Accelerator content is available only with a PowerCenter license.