Informatica Data Quality 10 Developer Specialist Set 2

The Pattern Parser is used in conjunction with which transformation?


Options are :

  • Token Parser
  • Standardizer
  • Exception
  • Labeler

Answer : Labeler

Which of the following is not true when it comes to creating and updating Reference Tables?


Options are :

  • Reference Tables can be updated from a Value Frequency list in the Developer
  • All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst
  • Reference Tables maintained in the Analyst and Developer tools are stored in separate repositories
  • Reference Tables can be imported and exported using the Developer Tool

Answer : All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst

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


Options are :

  • Double click on the transformation in the transformation palette
  • Click and drag the transformation onto the mapping
  • From the Mapping menu, select Add Transformation
  • Right click and choose Add Transformation on the mapping

Answer : Click and drag the transformation onto the mapping

PR000041- Informatica PC Data Integration9.xDeveloper Set 1

Which two of the following values can be parameterized in the Match transformation? Choose 2 answers


Options are :

  • Threshold values
  • Scoring methods
  • Match Field Inputs
  • Weights

Answer : Threshold values Match Field Inputs

Which two IDQ transformations can use parameters? Choose 2 answers


Options are :

  • Comparison
  • Decision
  • Case converter
  • Address Validation
  • Labeller

Answer : Decision Address Validation

Which definition describes Column Profiling?


Options are :

  • Column profiling automatically recognizes all functional and other dependencies in all tables, in particular the primary keys
  • Column profiling is the process of looking at every distinct value to determine the true minimum, maximum, data type, pattern and other important information about each attribute
  • Column profiling identifies the attributes for referential integrity
  • Column profiling is the process of creating a normalized schema for your target system

Answer : Column profiling is the process of creating a normalized schema for your target system

PR000041- Informatica PC Data Integration9.xDeveloper Set 2

Which of the following is not a function of Data Standardization?


Options are :

  • Standardization converts data to standardized formats
  • Standardization can remove "noise"
  • Standardization corrects and automatically updates the data in your source system
  • Standardization can remove or replace bad or inconsistent data

Answer : Standardization corrects and automatically updates the data in your source system

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


Options are :

  • PC 8.6.1 and higher
  • PC 8.51 and higher
  • All PC versions
  • PC 8.11, PC 8.51 and PC 8.6

Answer : PC 8.11, PC 8.51 and PC 8.6

During a project export, typically what will the output be from the export?


Options are :

  • An xml file containing all the mapping/mapplet/object definition
  • An xml file containing all the mapping/mapplet/object definition and a zip file containing all the reference data if required
  • The contents of each Project (including the dependent reference tables) in a zip file
  • Projects will be exported to an .irob file

Answer : An xml file containing all the mapping/mapplet/object definition and a zip file containing all the reference data if required

PR000041- Informatica PC Data Integration9.xDeveloper Set 3

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


Options are :

  • populations
  • accelerators
  • dictionaries
  • mapplets

Answer : dictionaries

Which of these statements is true about Data Rules?


Options are :

  • Data Rules must be run against the entire data set they are defined upon
  • Once created a Data Rule cannot be changed...it can only be deleted and re-created
  • A Data Rule created in the Analyst will appear as a mapplet with an Expression Transformation in the Developer
  • Data Rules can only be run on data in the project in which they were created

Answer : Data Rules can only be run on data in the project in which they were created

The IDQ and PowerCenter repositories all share the same schema.


Options are :

  • TRUE
  • FALSE

Answer : FALSE

PR000041- Informatica PC Data Integration9.xDeveloper Set 4

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


Options are :

  • Number of Columns in the file
  • Number of Rows in the source data
  • Amount of memory and speed of the processor on the server
  • All of the above

Answer : Number of Rows in the source data

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


Options are :

  • 0
  • 0.5
  • 1
  • 1.2

Answer : 1

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


Options are :

  • Column Profiling
  • Mid Stream Profiling
  • Join Analysis Profile
  • Comparative Profiling

Answer : Mid Stream Profiling

Which of the following is not a function of Data Standardization?


Options are :

  • Standardization converts data to standardized formats
  • Standardization can remove "noise"
  • Standardization corrects and automatically updates the data in your source system
  • Standardization can remove or replace bad or inconsistent data

Answer : Standardization corrects and automatically updates the data in your source system

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


Options are :

  • PC 8.6.1 and higher
  • PC 8.51 and higher
  • All PC versions
  • PC 8.11, PC 8.51 and PC 8.6

Answer : PC 8.11, PC 8.51 and PC 8.6

PR000041- Informatica PC Data Integration9.xDeveloper Set 5

During a project export, typically what will the output be from the export?


Options are :

  • An xml file containing all the mapping/mapplet/object definition
  • An xml file containing all the mapping/mapplet/object definition and a zip file containing all the reference data if required
  • The contents of each Project (including the dependent reference tables) in a zip file
  • Projects will be exported to an .irob file

Answer : An xml file containing all the mapping/mapplet/object definition and a zip file containing all the reference data if required

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


Options are :

  • populations
  • accelerators
  • dictionaries
  • mapplets

Answer : dictionaries

Which of these statements is true about Data Rules?


Options are :

  • Data Rules must be run against the entire data set they are defined upon
  • Once created a Data Rule cannot be changed...it can only be deleted and re-created
  • A Data Rule created in the Analyst will appear as a mapplet with an Expression Transformation in the Developer
  • Data Rules can only be run on data in the project in which they were created

Answer : Data Rules can only be run on data in the project in which they were created

PR000041- Informatica PC Data Integration9.xDeveloper Set 6

The IDQ and PowerCenter repositories all share the same schema.


Options are :

  • TRUE
  • FALSE

Answer : FALSE

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


Options are :

  • Number of Columns in the file
  • Number of Rows in the source data
  • Amount of memory and speed of the processor on the server
  • All of the above

Answer : Number of Rows in the source data

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


Options are :

  • 0
  • 0.5
  • 1
  • 1.2

Answer : 1

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


Options are :

  • Column Profiling
  • Mid Stream Profiling
  • Join Analysis Profile
  • Comparative Profiling

Answer : Mid Stream Profiling

What functionality does Data Quality Assistant provide? Choose 2 answers


Options are :

  • Consolidate duplicates into master record
  • Bad record management
  • Automatically consolidates data
  • ReGroup records for matching

Answer : Consolidate duplicates into master record Automatically consolidates data

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


Options are :

  • 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

Answer : The corrections are committed to the Staging DB and record is automatically pushed into another DB

Where does Scorecarding fit into the data quality process?


Options are :

  • Not at all - Scorecardlng is a separate process
  • At the start of the process only to assess current data quality levels
  • At the start and during regular intervals of the process to measure on-going data quality levels
  • At the end of the process only to prove the value of the data quality tool

Answer : At the start and during regular intervals of the process to measure on-going data quality levels

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


Options are :

  • Upper Case
  • Lower Case
  • Toggle merge Case
  • Sentence Case

Answer : Sentence Case

Select the item that is not a common symptom of data quality problems.


Options are :

  • Lack of trust and agreement in reporting
  • high customer satisfaction
  • Supply-chain 'out of stock' situations
  • Failure of IT projects

Answer : Lack of trust and agreement in reporting

Which of the following options is TRUE? The Advanced Import Wizard differs from the Basic in that


Options are :

  • The Advanced method allows conflict resolution and the Basic doesn't.
  • The Advanced Import Wizard allows objects to be imported into multiple target projects / folders and re-factor the dependencies.
  • Import steps can be undone in the Advanced Wizard but not in the Basic one
  • Users have a choice regarding which project objects are imported using Basic and Advanced.

Answer : Users have a choice regarding which project objects are imported using Basic and Advanced.

When matching, is it always necessary to group data?


Options are :

  • Only if the customer thinks it's a good idea
  • Only if the quality of the data is poor
  • Not always. If the dataset is small enough, grouping is not required
  • Yes, it's always necessary

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

What statement best describes IDQ's Web service capabilities?


Options are :

  • Mappings can only be created as a web service through PC integration
  • DQ has both native web service functionality and allows integration through PC
  • DQ mappings can only be made accessible through native means
  • DQ has not web service support

Answer : DQ mappings can only be made accessible through native means

How much data can DQA handle?


Options are :

  • 2000 rows and 20 columns
  • Million rows and 100 columns
  • There are no built-in restrictions. Large deployments will require more hardware and database tuning
  • Maximum 1 million rows and up to 10,000 columns

Answer : Million rows and 100 columns

Which parameter function is supported in IDQ 9.1?


Options are :

  • Set parameter for RTM Location/ Path
  • Set parameter for RTM Name
  • Ability to parameterise relational and flat-file connections
  • All of the above

Answer : All of the above

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


Options are :

  • Allow the wizard in Developer to automatically select the data types when creating the data objects.
  • Set all of the data types to text and length longer than those specified. The profiler will tell you what they should be.
  • Import the file into a database table before profiling.
  • Change the code page of the file to UTF-8.

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

A customer wants to be able to review data on the overall quality of each record, which technique should be used?


Options are :

  • Scorecarding
  • Matching
  • Grading
  • Standardization

Answer : Standardization

What types of profiling can be performed in the Developer Tool in Data Quality?


Options are :

  • Column Profiling, Primary Key Inference, Dependency Inference
  • Column and Join Profiling only
  • Column, Join Analysis, Mid Stream and Comparative Profiling
  • Column, Join Analysis, Mid Stream, Comparative, Primary and Foreign Key and Overlap Profiling

Answer : Column, Join Analysis, Mid Stream and Comparative Profiling

When importing a flat file into a project. Developer and Analyst Tool work exactly the same


Options are :

  • TRUE
  • FALSE

Answer : TRUE

Which transformation would you typically use to remove noise, symbols or words?


Options are :

  • Decision
  • Standardizer
  • Comparison
  • Parser

Answer : Standardizer

Accelerators provide which of the following? Choose 4 answers


Options are :

  • Rules
  • Reference tables
  • Demonstration mappings
  • Demonstration data objects
  • Profiles

Answer : Rules Demonstration mappings Demonstration data objects Profiles

Which of the following statements is true regarding DQ for Excel?


Options are :

  • DQ for Excel allows .xls files be used as source and target objects in mappings.
  • DQ for Excel enables non Informatica users to benefit from data quality rules by consuming and applying data quality rules directly from MS Excel data/ worksheets.
  • DQ for Excel can be used in any version of Excel.
  • In order to be able to use DQ for Excel, both PowerCenter and Data Quality Developer must be installed.

Answer : DQ for Excel enables non Informatica users to benefit from data quality rules by consuming and applying data quality rules directly from MS Excel data/ worksheets.

How is Accelerator content installed?


Options are :

  • Using the IDQ content installer.
  • It is imported through Developer.
  • The file extracted onto the server and it is automatically picked up after restarting the services
  • It is installed using the importer available in the Content Management service

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

When applying a reference table in the Labeler in token mode which of the following statements is correct?


Options are :

  • The order of the reference tables defined will not impact your results displayed
  • Selecting Inclusive mode will output items that are present in the reference table under the label provided
  • Selecting Exclusive mode will exclude Items that are present in the reference table
  • Any items that do not appear in the reference table are not displayed in the output

Answer : Selecting Inclusive mode will output items that are present in the reference table under the label provided

What is the best approach to implementing Address Validation in version 9.1?


Options are :

  • Run the addresses into the AV transformation without modification.
  • Take an iterative approach and review AV output. Determine why addresses did not validate and attempt to resolve the issue prior to running them in the AV transformation.
  • Canada Post defines the SERP certification standard for software applications that validate Canadian addresses.
  • Remove all punctuation before sending the address to the AV transformation.

Answer : Canada Post defines the SERP certification standard for software applications that validate Canadian addresses.

When profiling, why is it good to sort the value lists in both ascending and descending order?


Options are :

  • There is no specific reason. It is simply a step of an ordered best practice approach.
  • It is good because it is easier to determine if a field is numeric or text.
  • Values with leading spaces or punctuation will typically sort to the top or bottom making them easier to identify.
  • None of the above.

Answer : It is good because it is easier to determine if a field is numeric or text.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions