Data Quality 10 Developer, Professional Certification
Certification Exam | Data Quality | Version 10 | Skill Set Inventory
Data Quality 10 Developer, Professional Certification
Certification Overview
This test measures your competency as a member of a project implementation team. This involves an in-depth knowledge of Data Quality processes such as Profiling, Standardization, Matching, and Consolidation. You must select and configure the appropriate Data Quality transformations and build, debug and execute Data Quality mappings including integrating those mappings into Power Center if needed
When you are ready to test and become an Informatica Certified Professional (ICP), please follow these steps :
- Click Enroll and log in to your Informatica account.
- Click Add to Cart and complete your registration/purchase.
- Once you have registered go to My Training and View Your Transcript.
- Now you can simply Launch and take your test Anytime/Anywhere prior to your test’s expiry date.
Target Audience
- Students seeking certification as a Data Quality Developer Certified Professional
Prerequisites
The skills and knowledge areas measured by this test are focused on product core functionality inside the realm of a standard project implementation. Training materials, supporting documentation and practical experience may become sources of question development.
The suggested training prerequisites for this certification level are the completion of the following Informatica course(s):
- Data Quality: Data Quality Management for Developers (onDemand OR Instructor Led)
- Data Quality: Advanced Techniques (onDemand OR Instructor Led)
- Informatica Analyst (onDemand )
Skill Set Inventory |
||
Test takers will be measured on:
- Navigation through the Developer Tool
- Project Collaboration techniques such as Tags and Comments,
- Using Profiles and reference tables to share information with Analysts
- Profiling methods to identify data irregularities and inaccuracies.
- Converting a profile into a mapping
- Using mappings and mapplets to cleanse and standardize data
- Performing Address Validation
- Identifying duplicate records
- Automat and manual consolidation of e duplicate records into a master record
- Executing mappings in PowerCenter
- Deploying Data Quality Mappings in an Excel spreadsheet (connect to Web Services)
Test Domains
The test domains and the extent to which they are represented as an estimated percentage of the test follows:
| Title |
% of Test
|
| Informatica Overview | 10% |
| Analyst Collaboration | 10% |
| Profiling | 15% |
| Standardization/Mapplets | 10% |
| Address Validation | 5% |
| Matching | 10% |
| Consolidation and the DQA | 10% |
| Integration with PowerCenter | 5% |
| Object Import and Export | 5% |
| DQ for Excel | 5% |
| Parameters | 5% |
| Content | 10% |
Question Format
You may select from one or more response offerings to answer a question.
You will score the question correctly if your response accurately completes the statement or answers the question. Incorrect distractors are given as possible correct answers so that those without the required skills and experience may wrongly select that choice.
A passing grade of 70% is needed to achieve recognition as an Informatica Data Quality 10 Developer Certified Professional.
You are given 90 minutes to complete the test. Formats used in this test are:
- Multiple Choice: Select one option that best answers the question or completes the statement
- Multiple Response: Select all that apply to best answer the question or complete the statement
- True/False: After reading the statement or questions select the best answer
Test Policy
- You are eligible for one attempt and re-take, if needed, per test registration.
- If you do not pass on your first attempt:
- The purchase of the test will include one second-attempt if a student does not pass a test.
- You must wait two weeks after a failed test to take the test again.
- Any additional retakes are charged the current fee at the time of purchase.
- Promotions are excluded and cannot be combined.
Test Topics
The test will contain 70 questions comprised of topics that span across the sections listed below. In order to ensure that you are prepared for the test, review the subtopics with each section.
Informatica Overview
- Describe the Informatica 10 architecture and set up including the repositories required for installation
- Provide information on the Data Quality process and dimensions of data quality
Analyst Collaboration
- Use and describe the functionality of the Analyst Tool including Scorecarding, Reference Table Management, Tags, Filters, Profiles and Comments
- Describe how Analysts and Developers can collaborate on projects
- Describe the benefits of project collaboration to a team
Profiling
- Perform and interpret column, rule, comparative and mid-stream profiling
Standardization/Mapplets
- Be aware of where data standardization fits in the DQ process
- Apply, configure and troubleshoot data standardization transformations
- Differentiate between the various parsing techniques available
- Recognize how reference tables are used in the standardization process
Address Validation
- Verify the importance of Address Validation
- Configure the Address Validation transformation including explaining each mode that is available and what custom templates can be used for
- Interpret the AV outputs generated
Matching
- Develop and build match plans to identify duplicate or related data
- Differentiate between the matching algorithms available and explain how matching scores are
- Configure Identity Matching option for the match transformation
- Explain populations, the identity match strategies that are available and how they are used in Identity Matching
Consolidation and the DQA
- Explain Automatic and Manual consolidation techniques and configure the Transformations used for automatic consolidation
- Use the Exception Transformation to generate and populate the Bad Records and Duplicate Records tables
- Troubleshoot any problems that may occur
- Generate a survivor record in the DQA
- Remove duplicates using DQA
Integration with Power Center
- Explain how to integrate IDQ mappings and mapplets into PowerCenter Workflows including how content is handled
Object Import and Export
- Define the difference between the Basic and Advanced Import options available
- Explain Dependency conflict resolution and how it is handled
- Describe how to Export a Project
DQ for Excel
- Describe the requirements for integration for Excel
- Define the techniques for creating mappings for DQ for Excel
- Explain the Web service capabilities required for DQ for Excel
- Provide an explanation on how to use the Informatica ribbon in Excel
Parameters
- Explain what parameters are and why they are used including what parameter functions are supported
- Identify which Transformations can use parameters
- Describe the process of exporting mappings with parameters built in
Content
- Explain what Content is, what is contained in the Core Accelerator and why it is used in the Core Accelerator and why it is used
Sample Test Questions
| How are the Identity Match populations installed for Data Quality? | ||
| A. | X | None |
| B. | X | One |
| C. | X | Multiple, but only if you have been granted the Sources and Target privilege |
| D. | Correct | Multiple |
| Workflow recovery(introduced in version 9.5.1 HF1) property can be set in ___. | ||
| A. | Correct | Address reference data, identity population, and accelerator demonstration data |
| B. | X | Dictionaries only |
| C. | X | Address Validator Transformation and Address subscription data |
| D. | X | Pre-built Mappings, Demo Mappings, Dictionaries, Address Validator, Address subscription data |
| In IDQ scorecard results are stored in the Profile Warehouse | ||
| A. | Correct | True |
| B. | X | False |
| Which of the following is FALSE with regard to import/export functionality? | ||
| A. | X | Advanced Import Wizard allows users to perform fine grain conflict resolution. |
| B. | X | When using the Basic Method users must import entire Projects with a generic conflict resolution. |
| C. | X | When exporting, the user identifies a set of objects within a project, and all the objects plus their dependencies are exported to XML. |
| D. | Correct | When doing a Basic import the only conflict resolution available is Add Object to Target or Replace Object in Target |
| Which of the following will impact the total amount of time it takes to execute a column profiling process? | ||
| A. | X | Number of Columns in the file |
| B. | X | Number of Rows in the source data |
| C. | X | Amount of memory and speed of the processor on the servers |
| D. | Correct | All of the above |
Additional Information
Retake Policy: Current purchases of the test will include one second-attempt if a student does not pass a test. Any additional retakes are charged the current fee at the time of purchase. Promotions are excluded and cannot be combined. You must wait two weeks after a failed test to take the test again.
Informatica University has a community page so students can assist one another in their test preparation within the Informatica Network: https://network.informatica.com/welcome
QUESTIONS?
Certification Exam | Data Quality | Version 10 | Skill Set Inventory
Test takers will be measured on:
- Navigation through the Developer Tool
- Project Collaboration techniques such as Tags and Comments,
- Using Profiles and reference tables to share information with Analysts
- Profiling methods to identify data irregularities and inaccuracies.
- Converting a profile into a mapping
- Using mappings and mapplets to cleanse and standardize data
- Performing Address Validation
- Identifying duplicate records
- Automat and manual consolidation of e duplicate records into a master record
- Executing mappings in PowerCenter
- Deploying Data Quality Mappings in an Excel spreadsheet (connect to Web Services)
Test Domains
The test domains and the extent to which they are represented as an estimated percentage of the test follows:
| Title |
% of Test
|
| Informatica Overview | 10% |
| Analyst Collaboration | 10% |
| Profiling | 10% |
| Standardization/Mapplets | 20% |
| Matching | 15% |
| Consolidation and the DQA | 15% |
| Object Import and Export | 5% |
| DQ for Excel | 5% |
| Parameters | 5% |
| Content | 5% |
Question Format
You may select from one or more response offerings to answer a question.
You will score the question correctly if your response accurately completes the statement or answers the question. Incorrect distractors are given as possible correct answers so that those without the required skills and experience may wrongly select that choice.
A passing grade of 70% is needed to achieve recognition as an Informatica Data Quality 10 Developer Certified Professional.
You are given 90 minutes to complete the test. Formats used in this test are:
- Multiple Choice: Select one option that best answers the question or completes the statement
- Multiple Response: Select all that apply to best answer the question or complete the statement
- True/False: After reading the statement or questions select the best answer
Test Policy
- You are eligible for one attempt and re-take, if needed, per test registration.
- If you do not pass on your first attempt:
- The purchase of the test will include one second-attempt if a student does not pass a test.
- You must wait two weeks after a failed test to take the test again.
- Any additional retakes are charged the current fee at the time of purchase.
- Promotions are excluded and cannot be combined.
Test Topics
The test will contain 70 questions comprised of topics that span across the sections listed below. In order to ensure that you are prepared for the test, review the subtopics with each section.
|
Informatica Overview
Analyst Collaboration
Standardization/Mapplets
Address Validation
Matching
|
Consolidation and the DQA
Integration with Power Center
Object Import and Export
DQ for Excel
Parameters
Content
|
|---|
Sample Test Questions
| How are the Identity Match populations installed for Data Quality? | |||
| A. | X | None | |
| B. | X | One | |
| C. | X | Multiple, but only if you have been granted the Sources and Target privilege | |
| D. | Correct | Multiple | |
| Workflow recovery(introduced in version 9.5.1 HF1) property can be set in ___. | |||
| A. | Correct | Address reference data, identity population, and accelerator demonstration data | |
| B. | X | Dictionaries only | |
| C. | X | Address Validator Transformation and Address subscription data | |
| D. | X | Pre-built Mappings, Demo Mappings, Dictionaries, Address Validator, Address subscription data | |
| In IDQ scorecard results are stored in the Profile Warehouse | |||
| A. | Correct | True | |
| B. | X | False | |
|
|||
| A. | X | Advanced Import Wizard allows users to perform fine grain conflict resolution. | |
| B. | X | When using the Basic Method users must import entire Projects with a generic conflict resolution. | |
| C. | X | When exporting, the user identifies a set of objects within a project, and all the objects plus their dependencies are exported to XML. | |
| D. | Correct | When doing a Basic import the only conflict resolution available is Add Object to Target or Replace Object in Target | |
| Which of the following will impact the total amount of time it takes to execute a column profiling process? | |||
| A. | X | Number of Columns in the file | |
| B. | X | Number of Rows in the source data | |
| C. | X | Amount of memory and speed of the processor on the servers | |
| D. | Correct | All of the above | |
Additional Certification Support and Questions
Make sure you are familiar with our certification program guidelines BEFORE registering and taking the certification exam.
