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

Options are :

The corrections are committed to the Staging DB and an UPDATED_STATUS of Accepted is assigned to the record
The corrections are committed to the Staging DB and record is automatically pushed into another DB
Records are corrected and are sent to an Accepted DB table
Records are accepted and are pushed out to Target/Production DB

Answer(s): B

When would you use the DQA?

On suspect/exception records that fall out of a profile, standardization or matching process in IDQ
On records that could not be matched in a matching mapping
On records that are output from the Consolidation transformation
On records that are output from the Association transformation

Answer(s): C

When you select Suggestion List mode what statement is true?

The Address Validator transformation searches the address reference data and returns all addresses that are possible matches with the input address.
The Address Validator transformation searches the address reference data and returns the most likely candidate address.
The Address Validator transformation parses data into the suggested address fields without performing validation.
The Address Validator transformation will return various cleansed standardized versions of the input record for the user to choose from.

Answer(s): A

Which definition describes Column Profiling?

Options are :

Column profiling automatically recognizes all functional and other dependencies in all tables, in particular the primary keys
Column profiling is the process of looking at every distinct value to determine the true minimum, maximum, data type, pattern and other important information about each attribute
Column profiling identifies the attributes for referential integrity
Column profiling is the process of creating a normalized schema for your target system

Answer(s): D

Free DATA-QUALITY-10-DEVELOPER-SPECIALIST Exam Braindumps (page: 4)