DATA-QUALITY-10-DEVELOPER-SPECIALIST Online Practice Questions and Answers

With regard to a Basic Import which of the following is FALSE?

A. Once added, the target will display resolution for each folder imported.

B. A conflict resolution can be selected to apply to all imported objects.

C. Default is replace, options include rename or reuse.

D. The import can consist of an XML file and a Zip file containing the reference tables

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

A. No standardization is necessary, map input fields to the match transformation

B. Standardize address fields and use address line, locality, region and postcode fields as input to the match transformation

C. Standardize address fields and use the discrete address component fields, locality, region and postcode fields as input to the match transformation

D. Standardize address fields, create a group key field which contains parts of the address fields and only use the group key for address matching

Which are correct statements for IDQ grouping and matching?Choose 2 answers

A. IDQ field level matching does not utilize grouping

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

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

D. 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)

Which of the following will not work when adding transformations to mappings?

A. Double click on the transformation in the transformation palette

B. Click and drag the transformation onto the mapping

C. From the Mapping menu, select Add Transformation

D. Right click and choose Add Transformation on the mapping

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 of the following is not a function of Data Standardization?

A. Standardization converts data to standardized formats

B. Standardization can remove "noise"

C. Standardization corrects and automatically updates the data in your source system

D. Standardization can remove or replace bad or inconsistent data

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.

Select the transformation that will not allow a DQ mapplet to validate as a rule in version 9.1.

A. Expression Transformation

B. Address Validation Transformation

C. Aggregator Transformation

D. Labeler Transformation

Where does Scorecarding fit into the data quality process?

A. Not at all - Scorecardlng is a separate process

B. At the start of the process only to assess current data quality levels

C. At the start and during regular intervals of the process to measure on-going data quality levels

D. At the end of the process only to prove the value of the data quality tool

How much data can DQA handle?

A. 2000 rows and 20 columns

B. Million rows and 100 columns

C. There are no built-in restrictions. Large deployments will require more hardware and database tuning

D. Maximum 1 million rows and up to 10,000 columns