Informatica DATA-QUALITY-10-DEVELOPER-SPECIALIST Online Practice Questions and Exam Preparation

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

• Question 1:

  Which of the following will not work when adding transformations to mappings?

  A. Double click on the transformation in the transformation palette
  B. Click and drag the transformation onto the mapping
  C. From the Mapping menu, select Add Transformation
  D. Right click and choose Add Transformation on the mapping
  B. Click and drag the transformation onto the mapping

• Question 2:

  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
  C. Not always. If the dataset is small enough, grouping is not required

• Question 3:

  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
  B. Number of Rows in the source data

• Question 4:

  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
  D. All of the above

• Question 5:

  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.
  A. Allow the wizard in Developer to automatically select the data types when creating the data objects.

• Question 6:

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

  

  B. 0.5
  C. 1
  D. 1.2
  C. 1

• Question 7:

  The Pattern Parser is used in conjunction with which transformation?

  A. Token Parser
  B. Standardizer
  C. Exception
  D. Labeler
  D. Labeler

• Question 8:

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

  A. Company Executives and IT
  B. IT and Business
  C. IT and Administration
  D. Sales and Marketing
  A. Company Executives and IT

• Question 9:

  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.
  B. No additional steps are required. All Accelerator content is provided with the basic IDQ license.

• Question 10:

  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
  B. Mid Stream Profiling