DATA-QUALITY-10-DEVELOPER-SPECIALIST Exam Questions in PDF and Online

A customer has provided a number of delimited flat files that require profiling, but not file definition. What should you do first?

Options are :

Allow the wizard in Developer to automatically select the data types when creating the data objects.
Set all of the data types to text and length longer than those specified. The profiler will tell you what they should be.
Import the file into a database table before profiling.
Change the code page of the file to UTF-8.

Answer(s): A

With respect to field matching in IDQ, which best describes the approach to address matching?

No standardization is necessary, map input fields to the match transformation
Standardize address fields and use address line, locality, region and postcode fields as input to the match transformation
Standardize address fields and use the discrete address component fields, locality, region and postcode fields as input to the match transformation
Standardize address fields, create a group key field which contains parts of the address fields and only use the group key for address matching

Answer(s): D

Which transformations can be used in DQ for Excel?

Only mappings using a Case Converter and a Standardizer can be used on data in Excel.
Only mappings using non active transformations can be used in DQ for Excel.
All DQ transformations, including Matching and Consolidation can be used in DQ for Excel.
All DQ and Core Transformations can be used in DQ for Excel, there is no limitation.

Answer(s): D

Which of the following is NOT a required step for using DQ for Excel?

In Excel, choose to Add a service and either enter the URL address or select the .wsdl or .xml file to be imported.
Build and Test a web Services Mapping in the Developer Tool.
Export the Mapping to PowerCenter and test.
Create and Deploy the mapping as an Application.

Answer(s): A