Informatica Data-Quality-10-Developer-Specialist Exam Questions Free Practice Test

Viewing page 1 out of 3 pages

Viewing questions 1-10 out of questions

Questions # 1:

Where are IDQ mappings saved?

Options:

In the location specified in your Source object

In the Staging Database

In the Model Repository

On the Object Explorer tab in the Developer

Expert Solution

Questions # 2:

Which of the following is NOT a required step for using DQ for Excel?

Options:

In Excel, choose to Add a service and either enter the URL address or select the .wsdl or .xml file to be imported.

Build and Test a web Services Mapping in the Developer Tool.

Export the Mapping to PowerCenter and test.

Create and Deploy the mapping as an Application.

Expert Solution

Questions # 3:

What versions of PowerCenter can an IDQ 9.1 mapping be exported to?

Options are :

Options:

PC 8.6.1 and higher

PC 8.51 and higher

All PC versions

PC 8.11, PC 8.51 and PC 8.6

Expert Solution

Questions # 4:

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

Options are :

Options:

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

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

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

Accelerator content is available only with a PowerCenter license.

Expert Solution

Questions # 5:

What functionality does Data Quality Assistant provide? Choose 2 answers

Options are :

Options:

Consolidate duplicates into master record

Bad record management

Automatically consolidates data

ReGroup records for matching

Expert Solution

Questions # 6:

What happens to the records when corrections are made and a status of Accept is assigned?

Options are :

Options:

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

Expert Solution

Questions # 7:

When using field matching which is the best approach if using First Name as a match field?

Options:

Never use First Name as it is not necessary

No standardization of First Name field is necessary

Use the Edit Distance strategy

Create Soundex or NYSIIS value for the First Name and use it in match

Expert Solution

Questions # 8:

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

Options:

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

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

Default is replace, options include rename or reuse.

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

Expert Solution

Questions # 9:

What is the primary purpose of grouping data?

Options are :

Options:

standardize data in preparation for matching

normalize data in preparation for matching

Improve match performance

improve match results

Expert Solution

Questions # 10:

In version 9.1, what does the Content Management Service do?

Options:

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.

Expert Solution

Viewing page 1 out of 3 pages

Viewing questions 1-10 out of questions

Pass the Informatica Data Quality Data-Quality-10-Developer-Specialist Questions and answers with CertsForce