Free Data-Quality-10-Developer-Specialist – Data Quality 10: Developer Specialist Exam Practice Test Question

Select all that apply, then click Submit answer.

• ○

  Narrow

• ○

  Limited

• ○

  Typical

• ○

  Extended
  
  
  

Select all that apply, then click Submit answer.

• ○

  IDQ field level matching does not utilize grouping

• ○

  When field level matching is performed, the records within each group will be compared against each other

• ○

  When field level matching is performed, matching will be performed across multiple groups in a single match transformation.

• ○

  When field level matching is performed, matching will not be performed across groups, therefore it is imperative grouping is performed on a complete and accurate field(s)
  
  
  

Select all that apply, then click Submit answer.

• ○

  Rules

• ○

  Reference tables

• ○

  Demonstration mappings

• ○

  Demonstration data objects

• ○

  Profiles
  
  
  

Select all that apply, then click Submit answer.

• ○

  Consolidate duplicates into master record

• ○

  Bad record management

• ○

  Automatically consolidates data

• ○

  ReGroup records for matching
  
  
  

Select all that apply, then click Submit answer.

• ○

  Import accelerators directly to Power Center

• ○

  Install accelerators directly to PowerCenter

• ○

  Install accelerators into Developer

• ○

  Export accelerator mapplets and/or mappings to PowerCenter
  
  
  

Select an option, then click Submit answer.

• ○

  standardize data in preparation for matching

• ○

  normalize data in preparation for matching

• ○

  Improve match performance

• ○

  improve match results
  
  
  

Select an option, then click Submit answer.

• ○

  There is no specific reason. It is simply a step of an ordered best practice approach.

• ○

  It is good because it is easier to determine if a field is numeric or text.

• ○

  Values with leading spaces or punctuation will typically sort to the top or bottom making them easier to identify.

• ○

  None of the above.
  
  
  

Select an option, then click Submit answer.

• ○

  An xml file containing all the mapping/mapplet/object definition

• ○

  An xml file containing all the mapping/mapplet/object definition and a zip file containing all the reference data if required

• ○

  The contents of each Project (including the dependent reference tables) in a zip file

• ○

  Projects will be exported to an .irob file
  
  
  

Select an option, then click Submit answer.

• ○

  The Advanced method allows conflict resolution and the Basic doesn't.

• ○

  The Advanced Import Wizard allows objects to be imported into multiple target projects / folders and re-factor the dependencies.

• ○

  Import steps can be undone in the Advanced Wizard but not in the Basic one

• ○

  Users have a choice regarding which project objects are imported using Basic and
  Advanced.

Select an option, then click Submit answer.

• ○

  DQ for Excel allows .xls files be used as source and target objects in mappings.

• ○

  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.

• ○

  DQ for Excel can be used in any version of Excel.

• ○

  In order to be able to use DQ for Excel, both PowerCenter and Data Quality Developer must be installed.