Data Quality 10: Administrator, Specialist Certification

Certification Exam | Data Quality | Version 5 | Skill Set Inventory

Untitled Document
View Skill Set Inventory

Data Quality 10: Administrator, Specialist Certification

Certification Overview

This test measures your competency as a full member of a project implementation team, including: Your ability to install, configure and administer the Informatica Data Quality(IDQ) Product (Client, Server and Services), setup IDQ Domain Security (Users, Groups, Privileges on IDQ Services), IDQ Connections, and prebuilt Content (Accelerators, Address Data, Identity Populations), Upgrade, Monitoring and Reporting.

When you are ready to test and become an Informatica Certified Specialist (ICS), please follow these steps :

  1. Click Enroll and log in to your Informatica account.
  2. Click Add to Cart and complete your registration/purchase.
  3. Once you have registered go to My Training and View Your Transcript.
  4. Now you can simply Launch and take your test Anytime/Anywhere prior to your test’s expiry date.
The below can be used as a guide to preparing before taking the test. Included is an outline of the technical topics and subject areas that are covered in the test, test domain weighting, test objectives and topical content.

Enroll Now

 

    Skill Set Inventory


Test takers will be measured on:

  • Address Validation
  • Connections
  • Data Director & Workflows
  • Domain Management, Users & Architecture
  • DQ Content
  • DQ Matching
  • DQ Services
  • Identity Populations and Accelerators
  • Installation and Upgrade
  • Monitoring & Log
  • Operations
  • Reporting
  • Security, Users & Architecture

Test Domains

The test domains and the extent to which they are represented as an estimated percentage of the test follows:

Title
% of Test
Address Validation 10%
Connections 6%
Data Director & Workflows 8%
Domain Management, Users & Architecture DQ Content 9%
DQ Content 4%
DQ Matching 6%
DQ Services 13%
Installation & Upgrade 11%
Monitoring & Log 14%
Operations 9%
Reporting 6%
Security, Users & Architecture 4%

 

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 Certified Specialist (ICS) in Data Quality 10 Administrator.

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.

Address Validation

  • Be able to describe how Address Validation is installed and configured.
  • How to configure properties that may help Developers using AV in their mappings.

Connections

  • Be able to describe how to create DB connections and why.
  • Be able to describe which DQ Tool uses them and which tools can create them.

Data Director & Workflows

  • Be able to describe what is Data Director the application versus the service.
  • Describe Human Task flows and Workflows.
  • How to administrate workflows.

Domain Management, Users & Architecture

  • Be able to describe how to access the Administrator Console.
  • Be able to describe what is Domain and what it consists of.
  • Be able to navigate the Administrator Console to know where to configure services, security, and monitoring.

DQ Content

  • Be able to describe Data Quality Content & Installation.
  • Be able to describe the type of available of accelerators.

DQ Matching

  • Be able to describe upgrade of DQ Content.
  • Be able to describe the relationship between Matching and Disk utilization.
 

DQ Services

  • Be able to describe the types of services available.
  • Be able to describe content how to create and configure the services.

Installation and Upgrade

  • Be able to describe the installation and upgrade process and components needed to support development and production DQ Environment.
  • Be able describe the start up and shut down of services.

Monitoring & Log

  • Be able to describe the various types logs and their locations.
  • Be able to describe how you can monitor the activity in a domain.

Operations

  • Be able to describe the task and processes need to keep a DQ Environment up and running smoothly.
  • Be able to describe how  to troubleshoot issues to keep a DQ Environment up and running smoothly.

Reporting

  • Be able to describe types DQ reporting services available.
  • Be able to describe how to configure DQ reporting services.

Security, Users & Architecture

  • Be able to describe user permissions, privileges and permissions.
  • Be able to describe how to create users.

 Sample Test Questions

How are the Identity Match populations installed for Data Quality?
A. X Execute Content_installer_client.exe
B. X Execute Population_installer.exe
C. X Execute an import via the Developer client
D. Correct Execute Content_installer_server.exe
Workflow recovery (introduced in version 9.5.1 HF1) property can be set in ___.
A. Correct DQ Developer
B. X Administrator Console
C. X DQ Analyst
D. X Does not need to get set
After deleting an Application from Developer tool, the application still shows on Monitoring Tab.
In order to remove it permanently from the Monitoring tab, application must be stopped and undeployed.
A. Correct True
B. X False
In which property does Data Quality store the path to the population files on the Content Management Service?
A. X NLP Options
B. X Address Validation Properties
D. Correct Identity Properties
What is contained in the tables for the staging database?
A. X Staging database is used to store the cache file locations
B. X The Staging database is used to store Repository tables
C. X The Staging database is used to store PowerCenter mapping tables
D. Correct Staging database is used to store the Reference Data Tables

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

For more information on Informatica Certifications visit https://www.informatica.com/services-and-training/certification.html

To find the class that is right for you, fill out the form at the top of this page, or visit our website at http://www.informatica.com/us/services-and-training/training/. For onsite class information contact your local Education Sales Specialist.


Enroll Now


Test takers will be measured on:

  • Address Validation
  • Connections
  • Data Director & Workflows
  • Domain Management, Users & Architecture
  • DQ Content
  • DQ Matching
  • DQ Services
  • Identity Populations and Accelerators
  • Installation and Upgrade
  • Monitoring & Log
  • Operations
  • Reporting
  • Security, Users & Architecture

Test Domains

The test domains and the extent to which they are represented as an estimated percentage of the test follows:

Title
% of Test
Address Validation 10%
Connections 6%
Data Director & Workflows 8%
Domain Management, Users & Architecture DQ Content 9%
DQ Content 4%
DQ Matching 6%
DQ Services 13%
Installation & Upgrade 11%
Monitoring & Log 14%
Operations 9%
Reporting 6%
Security, Users & Architecture 4%

 

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 Certified Specialist (ICS) in Data Quality 10 Administrator.

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.

Address Validation

  • Be able to describe how Address Validation is installed and configured.
  • How to configure properties that may help Developers using AV in their mappings.

Connections

  • Be able to describe how to create DB connections and why.
  • Be able to describe which DQ Tool uses them and which tools can create them.

Data Director & Workflows

  • Be able to describe what is Data Director the application versus the service.
  • Describe Human Task flows and Workflows.
  • How to administrate workflows.

Domain Management, Users & Architecture

  • Be able to describe how to access the Administrator Console.
  • Be able to describe what is Domain and what it consists of.
  • Be able to navigate the Administrator Console to know where to configure services, security, and monitoring.

DQ Content

  • Be able to describe Data Quality Content & Installation.
  • Be able to describe the type of available of accelerators.

DQ Matching

  • Be able to describe upgrade of DQ Content.
  • Be able to describe the relationship between Matching and Disk utilization.

DQ Services

  • Be able to describe the types of services available.
  • Be able to describe content how to create and configure the services.

Installation and Upgrade

  • Be able to describe the installation and upgrade process and components needed to support development and production DQ Environment.
  • Be able describe the start up and shut down of services.

Monitoring & Log

  • Be able to describe the various types logs and their locations.
  • Be able to describe how you can monitor the activity in a domain.

Operations

  • Be able to describe the task and processes need to keep a DQ Environment up and running smoothly.
  • Be able to describe how  to troubleshoot issues to keep a DQ Environment up and running smoothly.

Reporting

  • Be able to describe types DQ reporting services available.
  • Be able to describe how to configure DQ reporting services.

Security, Users & Architecture

  • Be able to describe user permissions, privileges and permissions.
  • Be able to describe how to create users.

 Sample Test Questions

How are the Identity Match populations installed for Data Quality?
A. X Execute Content_installer_client.exe
B. X Execute Population_installer.exe
C. X Execute an import via the Developer client
D. Correct Execute Content_installer_server.exe
Workflow recovery (introduced in version 9.5.1 HF1) property can be set in ___.
A. Correct DQ Developer
B. X Administrator Console
C. X DQ Analyst
D. X Does not need to get set
After deleting an Application from Developer tool, the application still shows on Monitoring Tab. In order to remove it permanently from the Monitoring tab, application must be stopped and undeployed.
A. Correct True
B. X False
In which property does Data Quality store the path to the population files on the Content Management Service?
A. X NLP Options
B. X Address Validation Properties
D. Correct Identity Properties
What is contained in the tables for the staging database?
A. X Staging database is used to store the cache file locations
B. X The Staging database is used to store Repository tables
C. X The Staging database is used to store PowerCenter mapping tables
D. Correct Staging database is used to store the Reference Data Tables

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

For more information on Informatica Certifications visit https://www.informatica.com/services-and-training/certification.html

To find the class that is right for you, fill out the form at the top of this page, or visit our website at http://www.informatica.com/us/services-and-training/training/. For onsite class information contact your local Education Sales Specialist.


Enroll Now

QUESTIONS?

Certification Exam | Data Quality| Version 10 | Skill Set Inventory

Print Friendly and PDF