Informatica Informatica Certifications DATA-QUALITY-10-DEVELOPER-SPECIALIST Questions & Answers

• Question 21:

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

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

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

  C. Export the Mapping to PowerCenter and test.

  D. Create and Deploy the mapping as an Application.

  Correct Answer: A

• Question 22:

  Which two are index key levels in Identity Matching? Choose 2 answers

  A. Narrow

  B. Limited

  C. Typical

  D. Extended

  Correct Answer: AC

• Question 23:

  When would you use the DQA?

  A. On suspect/exception records that fall out of a profile, standardization or matching process in IDQ

  B. On records that could not be matched in a matching mapping

  C. On records that are output from the Consolidation transformation

  D. On records that are output from the Association transformation

  Correct Answer: C

• Question 24:

  What functionality does Data Quality Assistant provide? Choose 2 answers

  A. Consolidate duplicates into master record

  B. Bad record management

  C. Automatically consolidates data

  D. ReGroup records for matching

  Correct Answer: AC

• Question 25:

  When is sampling for Profiling a good idea? Select the best answer.

  A. When the data set contains sensitive information like credit card numbers.

  B. When the probability of data quality issues is small.

  C. When the client provides assurances the quality of the data is good.

  D. When the volume of data is large and there are storage and/or time constraints.

  Correct Answer: D

• Question 26:

  You have just standardized values in a field and you would like to review how the modified dataappears alongside the original data. Which profiling method would best be suited for this?

  A. Column Profiling

  B. Mid Stream Profiling

  C. Join Analysis Profile D. Comparative Profiling

  Correct Answer: B

• Question 27:

  If the inputs to the Edit Distance Strategy below are 'john' and NULL, what will the resultingmatch score be?

  

  A. 0

  B. 0.5

  C. 1

  D. 1.2

  Correct Answer: C

• Question 28:

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

  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

  Correct Answer: B

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

• Question 29:

  The IDQ and PowerCenter repositories all share the same schema.

  A. TRUE

  B. FALSE

  Correct Answer: B

• Question 30:

  Which Informatica option provides solutions to common data quality issues in a country, region,or industry? Choose 1 answer.

  A. populations

  B. accelerators

  C. dictionaries

  D. mapplets

  Correct Answer: C