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 is stored in the Staging repository?

A. Reference Tables

B. Mappings

C. Reference Tables and Audit information

D. Authentication details

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

What functionality does Data Quality Assistant provide? Choose 2 answers

A. Consolidate duplicates into master record

B. Bad record management

C. Automatically consolidates data

D. ReGroup records for matching

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