Informatica Data Quality DATA-QUALITY-10-DEVELOPER-SPECIALIST Questions & Answers

• Question 1:

  What Data Quality Transformation utilizes Identity populations?

  A. Key Generator Transformation

  B. Match Transformation

  C. Edit Distance Transformation

  D. Comparison Transformation

  Correct Answer: C

• Question 2:

  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

  Correct Answer: B

• Question 3:

  Which phrase best describes how organizations should view their approach to data quality?

  A. As a one-off project addressing the issues in their data warehouse in batch

  B. As an ongoing process addressing issues over time with a combination of fit-for-purpose approaches

  C. As a real-time process addressing issues as they are introduced

  D. As a batch process to be implemented to run on a monthly basis

  Correct Answer: A

  Reference: http://dssresources.com/papers/features/langseth/langseth02082004.html

• Question 4:

  What is the primary purpose of grouping data?

  A. standardize data in preparation for matching

  B. normalize data in preparation for matching

  C. Improve match performance

  D. improve match results

  Correct Answer: C

• Question 5:

  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.

  Correct Answer: B

• Question 6:

  A customer has provided a number of delimited flat files that require profiling, but not filedefinition. What should you do first?

  A. Allow the wizard in Developer to automatically select the data types when creating the data objects.

  B. Set all of the data types to text and length longer than those specified. The profiler will tell you what they should be.

  C. Import the file into a database table before profiling.

  D. Change the code page of the file to UTF-8.

  Correct Answer: A

  Reference: http://in.mathworks.com/help/simulink/ug/working-with-data-objects.html

• Question 7:

  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

  Correct Answer: D

• Question 8:

  How much data can DQA handle?

  A. 2000 rows and 20 columns

  B. Million rows and 100 columns

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

  D. Maximum 1 million rows and up to 10,000 columns

  Correct Answer: B

• Question 9:

  What statement best describes IDQ's Web service capabilities?

  A. Mappings can only be created as a web service through PC integration

  B. DQ has both native web service functionality and allows integration through PC

  C. DQ mappings can only be made accessible through native means

  D. DQ has not web service support

  Correct Answer: C

• Question 10:

  When matching, is it always necessary to group data?

  A. Only if the customer thinks it's a good idea

  B. Only if the quality of the data is poor

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

  D. Yes, it's always necessary

  Correct Answer: C