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

When sharing Projects across teams which of the following is True?

A. The same icon is used to indicate a shared and non shared project.

B. Comments that are added to a profile in the Analyst can be viewed by the Developer in the same profile in the Developer Tool.

C. Permissions need to be assigned to each Folder within the project so users of shared projects can access all the objects.

D. Rules that were created In the Analyst Tool will be visible In the Developer but Developer built rules can not be made available in the Analyst.

Which is the best combination of functions to effectively implement a data quality project?

A. Company Executives and IT

B. IT and Business

C. IT and Administration

D. Sales and Marketing

When you select Suggestion List mode what statement is true?

A. The Address Validator transformation searches the address reference data and returns all addresses that are possible matches with the input address.

B. The Address Validator transformation searches the address reference data and returns the most likely candidate address.

C. The Address Validator transformation parses data into the suggested address fields without performing validation.

D. The Address Validator transformation will return various cleansed standardized versions of the input record for the user to choose from.

Which is true with regard to Profiles?

A. The Developer can only review Profiles created by the Analyst but can not create any profiles themselves

B. The Developer can take Analyst built profiles with rules and generate a mapping ensuring lossless translation of Information between specification and Implementation.

C. Comments, Tags and Rules can only be applied to profiles in the Analyst Tool

D. Only one Tag can be applied to each object in a project.

Which transformation would you typically use to remove noise, symbols or words?

A. Decision

B. Standardizer

C. Comparison

D. Parser

When applying a reference table in the Labeler in token mode which of the following statementsis correct?

A. The order of the reference tables defined will not impact your results displayed

B. Selecting Inclusive mode will output items that are present in the reference table under the label provided

C. Selecting Exclusive mode will exclude Items that are present in the reference table

D. Any items that do not appear in the reference table are not displayed in the output

Which strategy pairs characters together as its match algorithm?

A. Edit Distance

B. Bigram

C. Hamming Distance

D. Jaro Distance

Should data be standardized before it reaches the Address Validator?

A. Yes, street and directional abbreviations should always be expanded to their unabbreviated form.

B. No, any change may cause problems to the AV transformation.

C. Yes, if after review, specific problems have been identified that are causing address to not validate that otherwise would.

D. Yes, they should all be upper case.

Which of these statements is true about Data Rules?

A. Data Rules must be run against the entire data set they are defined upon

B. Once created a Data Rule cannot be changed...it can only be deleted and re-created

C. A Data Rule created in the Analyst will appear as a mapplet with an Expression Transformation in the Developer

D. Data Rules can only be run on data in the project in which they were created

When is sampling for Profiling a good idea? Select the best answer.

A. When the data set contains sensitive information like credit card numbers.

B. When the probability of data quality issues is small.

C. When the client provides assurances the quality of the data is good.

D. When the volume of data is large and there are storage and/or time constraints.

IDQ parameters can be defined at what levels? Choose all that apply.

A. Mappings

B. Mapplets

C. Re-usable Transformations

D. Rules

Which of the following cannot be executed in BOTH the Analyst and the Developer Tool?

A. A rule created in the Analyst Tool

B. A mapplet created in the Developer Tool and validated as a rule

C. A mapplet created in the Developer Tool and validated as a mapplet

D. A reusable rule created in the Analyst Tool

Which phrase best describes how organizations should view their approach to data quality?

A. As a one-off project addressing the issues in their data warehouse in batch

B. As an ongoing process addressing issues over time with a combination of fit-for-purpose approaches

C. As a real-time process addressing issues as they are introduced

D. As a batch process to be implemented to run on a monthly basis