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

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

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.

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

A. Labeler

B. Decision

C. Standardizer

D. Parser

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.

Accelerators provide which of the following? Choose 4 answers

A. Rules

B. Reference tables

C. Demonstration mappings

D. Demonstration data objects

E. Profiles

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 of the following is not true when it comes to creating and updating Reference Tables?

A. Reference Tables can be updated from a Value Frequency list in the Developer

B. All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst

C. Reference Tables maintained in the Analyst and Developer tools are stored in separate repositories

D. Reference Tables can be imported and exported using the Developer Tool

During a project export, typically what will the output be from the export?

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

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

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

D. Projects will be exported to an .irob file

Which parameter function is supported in IDQ 9.1?

A. Set parameter for RTM Location/ Path

B. Set parameter for RTM Name

C. Ability to parameterise relational and flat-file connections

D. All of the above

What is required for customers to access and use IDQ Accelerator content?

A. Customers must license each Accelerator pack individually to download and use the content.

B. No additional steps are required. All Accelerator content is provided with the basic IDQ license.

C. IDQ customers simply need to request an IPS resource to download and install the content.

D. Accelerator content is available only with a PowerCenter license.

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