Weekend Sale - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65percent

Welcome To DumpsPedia

Data-Quality-10-Developer-Specialist Sample Questions Answers

Questions 4

What transformation would you use to standardize data using a reference table?

Options:

A.

Labeler

B.

Decision

C.

Standardizer

D.

Parser

Buy Now
Questions 5

Which of the following will Impact the total amount of time it takes to execute a column profiling process?

Options are :

Options:

A.

Number of Columns in the file

B.

Number of Rows in the source data

C.

Amount of memory and speed of the processor on the server

D.

All of the above

Buy Now
Questions 6

Which DQ Transformations can be used to automatically consolidate matched records?

Options:

A.

Consolidation

B.

Match and Association

C.

Key Gen and Consolidation

D.

Key Gen, Association and Consolidation

Buy Now
Questions 7

In the Case Converter transformation which of the following is not a valid Case Transform?

Options are :

Options:

A.

Upper Case

B.

Lower Case

C.

Toggle merge Case

D.

Sentence Case

Buy Now
Questions 8

Which two of the following values can be parameterized in the Match transformation? Choose 2 answers

Options are :

Options:

A.

Threshold values

B.

Scoring methods

C.

Match Field Inputs

D.

Weights

Buy Now
Questions 9

Which transformations can be used in DQ for Excel?

Options:

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.

Buy Now
Questions 10

How is the data loaded into DQA and how is it configured?

Options:

A.

By running the DQ Client installer

B.

The Analyst defines the table in the Analyst tool, and the mappings in the Developer tool create and populate the appropriate tables

C.

The Analyst populates and creates the table in the Analyst tool

D.

The Administrator needs to create a DQA Service and associate it with the staging database

Buy Now
Questions 11

Which is true with regard to Profiles?

Options:

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.

Buy Now
Questions 12

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

Options:

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

Buy Now
Questions 13

Which definition describes Column Profiling?

Options are :

Options:

A.

Column profiling automatically recognizes all functional and other dependencies in all tables, in particular the primary keys

B.

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

C.

Column profiling identifies the attributes for referential integrity

D.

Column profiling is the process of creating a normalized schema for your target system

Buy Now
Questions 14

When changes are made to a mapplet in IDQ 9.1 that has been integrated into PowerCenter, how are those changes propagated to the integrated mapplet?

Options:

A.

Those changes are automatically propagated and managed through domain settings.

B.

The user must manually re-export the IDQ mapplet to PowerCenter.

C.

The IDQ versioning system automatically synchs with PowerCenter and updates themapplet to the most current version.

D.

None of the above.

Buy Now
Questions 15

You want to derive the gender from a firstname, how would you do this?

Options:

A.

Use a reference table with the firstname as the valid column and the gender in the second column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

B.

Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Valid Values when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

C.

Use a decision and create an If then else rule eg: If fname = 'Jennifer' then gender: = 'F' Endif

D.

Use a reference table with the gender as the valid column and the firstname in next column. Then choose to Replace Reference Table Matches with Custom Strings when applying the reference table in a strategy in the Standardizer. Use the firstname as input.

Buy Now
Questions 16

Accelerators provide which of the following? Choose 4 answers

Options are :

Options:

A.

Rules

B.

Reference tables

C.

Demonstration mappings

D.

Demonstration data objects

E.

Profiles

Buy Now
Questions 17

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

Options:

A.

Company Executives & IT

B.

IT & Business

C.

IT & Administration

D.

Sales & Marketing

Buy Now
Questions 18

When you select Suggestion List mode what statement is true?

Options:

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.

Buy Now
Questions 19

A customer wants to be able to review data on the overall quality of each record, which technique should be used?

Options are :

Options:

A.

Scorecarding

B.

Matching

C.

Grading

D.

Standardization

Buy Now
Questions 20

What types of profiling can be performed in the Developer Tool in Data Quality?

Options are :

Options:

A.

Column Profiling, Primary Key Inference, Dependency Inference

B.

Column and Join Profiling only

C.

Column, Join Analysis, Mid Stream and Comparative Profiling

D.

Column, Join Analysis, Mid Stream, Comparative, Primary and Foreign Key and Overlap Profiling

Buy Now
Questions 21

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

Options:

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)

Buy Now
Exam Code: Data-Quality-10-Developer-Specialist
Exam Name: Data Quality 10: Developer Specialist Exam
Last Update: Dec 10, 2024
Questions: 70
$57.75  $164.99
$43.75  $124.99
$36.75  $104.99
buy now Data-Quality-10-Developer-Specialist