Practice Free Data-Quality-10-Developer-Specialist Data Quality 10: Developer Specialist Exam Exam Questions Answers With Explanation

Upper Case

Lower Case

Toggle merge Case

Sentence Case

Mappings

Mapplets

Re-usable Transformations

Rules

standardize data in preparation for matching

normalize data in preparation for matching

Improve match performance

improve match results

Double click on the transformation in the transformation palette

Click and drag the transformation onto the mapping

From the Mapping menu, select Add Transformation

Right click and choose Add Transformation on the mapping

Import accelerators directly to Power Center

Install accelerators directly to PowerCenter

Install accelerators into Developer

Export accelerator mapplets and/or mappings to PowerCenter

In the location specified in your Source object

In the Staging Database

In the Model Repository

On the Object Explorer tab in the Developer

2000 rows and 20 columns

Million rows and 100 columns

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

Maximum 1 million rows and up to 10,000 columns

The corrections are committed to the Staging DB and an UPDATED_STATUS of Accepted is assigned to the record

The corrections are committed to the Staging DB and record is automatically pushed into another DB

Records are corrected and are sent to an Accepted DB table

Records are accepted and are pushed out to Target/Production DB

Company Executives & IT

IT & Business

IT & Administration

Sales & Marketing

It manages the dictionaries created in the Analyst Tool.

It provides the DIS with information on the location of the address validation data as well as license and other AV configuration settings.

It runs Identity Matching

It makes the Profile repository available to outside reporting applications like Jaspersoft.

Those changes are automatically propagated and managed through domain settings.

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

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

None of the above.

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

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

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

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.

Narrow

Limited

Typical

Extended

Not at all - Scorecardlng is a separate process

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

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

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

Only if the customer thinks it's a good idea

Only if the quality of the data is poor

Not always. If the dataset is small enough, grouping is not required

Yes, it's always necessary

Number of Columns in the file

Number of Rows in the source data

Amount of memory and speed of the processor on the server

All of the above