Free DATA-QUALITY-10-DEVELOPER-SPECIALIST Exam Dumps Preview

Question 1

Single choice

How is Accelerator content installed?

1. A

   Using the IDQ content installer.

2. B

   It is imported through Developer.

3. C

   The file extracted onto the server and it is automatically picked up after restarting the services

4. D

   It is installed using the importer available in the Content Management service

Reveal answer details Close answer details

Correct answerC

Question 2

Single choice

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

1. A

   Company Executives & IT

2. B

   IT & Business

3. C

   IT & Administration

4. D

   Sales & Marketing

Reveal answer details Close answer details

Correct answerA

Explanation

References:
http://www2.sas.com/proceedings/sugi29/098-29.pdf

Question 3

Multiple choice

What functionality does Data Quality Assistant provide? Choose 2 answers

1. A

   Consolidate duplicates into master record

2. B

   Bad record management

3. C

   Automatically consolidates data

4. D

   ReGroup records for matching

Reveal answer details Close answer details

Correct answersA, C

Question 4

Single choice

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

1. A

   Consolidation

2. B

   Match and Association

3. C

   Key Gen and Consolidation

4. D

   Key Gen, Association and Consolidation

Reveal answer details Close answer details

Correct answerB

Explanation

References:
http://www.infoflow.co.za/pdfs/Informatica%20Data%20Quality%20Developer%209x%20Training%20Data%20Sheet.pdf

Question 5

Single choice

The Pattern Parser is used in conjunction with which transformation?

1. A

   Token Parser

2. B

   Standardizer

3. C

   Exception

4. D

   Labeler

Reveal answer details Close answer details

Correct answerD

Question 6

Single choice

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

1. A

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

2. B

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

3. C

   Default is replace, options include rename or reuse.

4. D

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

Reveal answer details Close answer details

Correct answerC

Question 7

Single choice

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

1. A

   Number of Columns in the file

2. B

   Number of Rows in the source data

3. C

   Amount of memory and speed of the processor on the server

4. D

   All of the above

Reveal answer details Close answer details

Correct answerB

Explanation

References:
http://docs.oracle.com/cd/B31080_01/doc/owb.102/b28223/concept_data_quality.htm

Question 8

Single choice

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

1. A

   Upper Case

2. B

   Lower Case

3. C

   Toggle merge Case

4. D

   Sentence Case

Reveal answer details Close answer details

Correct answerD

Question 9

Multiple choice

Which two IDQ transformations can use parameters? Choose 2 answers

1. A

   Comparison

2. B

   Decision

3. C

   Case converter

4. D

   Address Validation

5. E

   Labeller

Reveal answer details Close answer details

Correct answersB, D

Question 10

Single choice

What Address Validator output field should you use to determine the quality of addressvalidated?

1. A

   Locality / City

2. B

   ElementlnputStatus

3. C

   Match Code

4. D

   MSA

Reveal answer details Close answer details

Correct answerA

Question 11

Multiple choice

Which statements describe the Consolidation Transformation?Choose 2 answers

1. A

   a passive transformation

2. B

   an active transformation

3. C

   a transformation which is found only in PowerCenter

4. D

   creates a single, consolidated record from records identified as possible duplicates by the Match transformation

Reveal answer details Close answer details

Correct answersB, D