PR000005 Online Practice Questions and Answers

You want to derive the gender from a firstname, how would you do this?

A. Use a reference table with the firstname as the valid column and the gender in the second column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

B. Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

C. Use a decision and create an If then else rule eg: If fname = 'Jennifer' then gender: = 'F' Endif

D. Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Custom Strings when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

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

Which strategy pairs characters together as its match algorithm?

A. Edit Distance

B. Bigram

C. Hamming Distance

D. Jaro Distance

Which DQ Transformations can be used to automatically consolidate matched records?

A. Consolidation

B. Match and Association

C. Key Gen and Consolidation

D. Key Gen, Association and Consolidation

Which Informatica option provides solutions to common data quality issues in a country, region,or industry? Choose 1 answer.

A. populations

B. accelerators

C. dictionaries

D. mapplets

The IDQ and PowerCenter repositories all share the same schema.

A. TRUE

B. FALSE

When would you use the DQA?

A. On suspect/exception records that fall out of a profile, standardization or matching process in IDQ

B. On records that could not be matched in a matching mapping

C. On records that are output from the Consolidation transformation

D. On records that are output from the Association transformation

Which transformations can be used in DQ for Excel?

A. Only mappings using a Case Converter and a Standardizer can be used on data in Excel.

B. Only mappings using non active transformations can be used in DQ for Excel.

C. All DQ transformations, including Matching and Consolidation can be used in DQ for Excel.

D. All DQ and Core Transformations can be used in DQ for Excel, there is no limitation.

Which phrase best describes how organizations should view their approach to data quality?

A. As a one-off project addressing the issues in their data warehouse in batch

B. As an ongoing process addressing issues over time with a combination of fit-for-purpose approaches

C. As a real-time process addressing issues as they are introduced

D. As a batch process to be implemented to run on a monthly basis