PowerCenter Data Integration 10 Administrator, Professional Certification

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

Untitled Document
View Skill Set Inventory

PowerCenter Data Integration 10 Administrator, Professional Certification

Certification Overview

This test measures your competency across installation and configuration, architecture, server maintenance, security, deployment, PowerCenter Repository management, web services, command line utilities and Informatica Velocity Best Practices and Implementation Methodology as a full member of a project implementation team.

When you are ready to test and become an Informatica Certified Professional (ICP), 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

 

Target Audience

  • Students seeking certification as a PowerCenter Administrator 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):

    Skill Set Inventory

Test takers will be measured on:

  • Architecture
  • Server Maintenance
  • Security
  • Deployment
  • License Keys
  • Repository Management
  • Web Services
  • Command Line Utilities
  • Metadata Reporting
  • Administrator Tool

Test Domains

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

Title
% of Test
Architecture 20%
Installation 3%
License Keys 3%
Option-Based Questions 1%
Repository Management 8%
Security 53%
Service Maintenance 11%

 

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 PowerCenter Data Integration 10 Administrator 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 Architecture

  • How the different pieces of the architecture fit together
  • How the different services relate to one another
  • The function of each service
  • The different types of nodes & how they function
  • Be familiar with the client applications & how they interact with the domain
  • Be familiar with the Administrator tool
  • Domain alerts & how they’re configured
  • Domain migration
  • The license service

Service Maintenance

  • Know the function of each service
  • Know which services support which client applications
  • Know how to configure each service
  • Generate a diagnostics file

Security

  • Be able to define the terms “user,” “group,” “privilege,” “role,” & “permission”
  • Know how to configure users, groups, privileges, roles, & permissions
  • Know how users, groups, privileges, roles, & permissions relate to one another
  • Know the Security page in the Administrator Tool
  • Know how to assign users to groups
  • Know how to assign privileges & roles to groups or users
  • Know how to set up permissions in the various applications
  • Know how to set up permissions in the domain
  • Know how Informatica authentication works
  • Default administrator accounts
  • Know the difference between native & LDAP security
  • Know how to configure native & LDAP security
  • Know the difference between assigned & inherited privileges
  • Know the difference between assigned & inherited permissions
  • Know the difference between a system & a custom role
  • Privilege groups
  • Direct, inherited, & effective domain permissions
  • Know how to configure operating system profiles
  • Subject area implementation

Deployment

  • Know the different methods of PowerCenter metadata deployment
  • Advantages & disadvantages of each deployment method
  • Best practices around deployment

License Keys

  • Know the role of the license key file
  • Know how to assign services to a license
  • Know how to view options for a license

Repository Management

  • Know the functionality of each of the client tools
  • Know how to set folder permissions in PowerCenter
  • PowerCenter shortcuts
  • Know how to configure PowerCenter connections
  • Types of objects reside in a PowerCenter repository

Web Services

  • Informatica web service architecture
  • Know the messaging standard Informatica uses
  • Know the role of a WSDL file as it relates to an Informatica web service
  • Know how to configure an Informatica real-time web service

Command Line Interface

  • Function of each CLI
  • Know which CLIs have an interactive mode
  • Know the successful CLI return code
  • Know how to capture the CLI return code

Metadata Reporting

  • Role of the MX views
  • Know the function of “Save MX Data”
  • Metadata extensions
  • Know how to create & manage non-reusable metadata extensions
  • Know how to create & manage reusable metadata extensions

Administrator Tool

  • Know configurations
  • Understand connections and actions

 Sample Test Questions

The Service Manager runs which functions on the Master Gateway Node in the domain?
A. X ETL, Configuration, and Alerting
B. X Security, Web Services, and Alerting
C. X Web Services, Configuration, and Licensing
D. Correct Security, Configuration, and Alerting
Which of the following actions can you perform in the PowerCenter Workflow Manager?
A. Correct Create and execute workflows
B. X Create, execute, and monitor workflows
C. X Execute and monitor workflows
D. X None of the above
If a user has permissions on a domain folder in the Administrator, then that user has permissions on all objects in that folder.
A. Correct True
B. X False
What are the three types of domain object permissions?
A. X Direct, Inherited, Post Facto
B. X Indirect, Inherited, Effective
C. X Direct, Assigned, Effective
D. Correct Direct, Inherited, Effective
When assigning a license to an application service, which statement is correct?
A. X You can assign licenses so long as you have the license object privilege
B. X The license must have high availability functionality
C. X The application service must have already had a license assigned to it
D. Correct The application service cannot have any licenses assigned to it

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 Integration | Version 10 | Skill Set Inventory

Test takers will be measured on:

  • Architecture
  • Server Maintenance
  • Security
  • Deployment
  • License Keys
  • Repository Management
  • Web Services
  • Command Line Utilities
  • Metadata Reporting
  • Administrator Tool

Test Domains

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

Title
% of Test
Architecture 20%
Installation 3%
License Keys 3%
Option-Based Questions 1%
Repository Management 8%
Security 53%
Service Maintenance 11%

 

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 PowerCenter Data Integration 10 Administrator 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 Architecture
  • How the different pieces of the architecture fit together
  • How the different services relate to one another
  • The function of each service
  • The different types of nodes & how they function
  • Be familiar with the client applications & how they interact with the domain
  • Be familiar with the Administrator tool
  • Domain alerts & how they’re configured
  • Domain migration
  • The license service
Service Maintenance
  • Know the function of each service
  • Know which services support which client applications
  • Know how to configure each service
  • Generate a diagnostics file
Security
  • Be able to define the terms “user,” “group,” “privilege,” “role,” & “permission”
  • Know how to configure users, groups, privileges, roles, & permissions
  • Know how users, groups, privileges, roles, & permissions relate to one another
  • Know the Security page in the Administrator Tool
  • Know how to assign users to groups
  • Know how to assign privileges & roles to groups or users
  • Know how to set up permissions in the various applications
  • Know how to set up permissions in the domain
  • Know how Informatica authentication works
  • Default administrator accounts
  • Know the difference between native & LDAP security
  • Know how to configure native & LDAP security
  • Know the difference between assigned & inherited privileges
  • Know the difference between assigned & inherited permissions
  • Know the difference between a system & a custom role
  • Privilege groups
  • Direct, inherited, & effective domain permissions
  • Know how to configure operating system profiles
  • Subject area implementation

  Deployment
  • Know the different methods of PowerCenter metadata deployment
  • Advantages & disadvantages of each deployment method
  • Best practices around deployment
License Keys
  • Know the role of the license key file
  • Know how to assign services to a license
  • Know how to view options for a license
Repository Management
  • Know the functionality of each of the client tools
  • Know how to set folder permissions in PowerCenter
  • PowerCenter shortcuts
  • Know how to configure PowerCenter connections
  • Types of objects reside in a PowerCenter repository
Web Services
  • Informatica web service architecture
  • Know the messaging standard Informatica uses
  • Know the role of a WSDL file as it relates to an Informatica web service
  • Know how to configure an Informatica real-time web service
Command Line Interface
  • Function of each CLI
  • Know which CLIs have an interactive mode
  • Know the successful CLI return code
  • Know how to capture the CLI return code
Metadata Reporting
  • Role of the MX views
  • Know the function of “Save MX Data”
  • Metadata extensions
  • Know how to create & manage non-reusable metadata extensions
  • Know how to create & manage reusable metadata extensions
Administrator Tool
  • Know configurations
  • Understand connections and actions

 Sample Test Questions

The Service Manager runs which functions on the Master Gateway Node in the domain?
A. X ETL, Configuration, and Alerting
B. X Security, Web Services, and Alerting
C. X Web Services, Configuration, and Licensing
D. Correct Security, Configuration, and Alerting
Which of the following actions can you perform in the PowerCenter Workflow Manager?
A. Correct Create and execute workflows
B. X Create, execute, and monitor workflows
C. X Execute and monitor workflows
D. X None of the above
If a user has permissions on a domain folder in the Administrator, then that user has permissions on all objects in that folder.
A. Correct True
B. X False
What are the three types of domain object permissions?
A. X Direct, Inherited, Post Facto
B. X Indirect, Inherited, Effective
C. X Direct, Assigned, Effective
D. Correct Direct, Inherited, Effective
When assigning a license to an application service, which statement is correct?
A. X You can assign licenses so long as you have the license object privilege
B. X The license must have high availability functionality
C. X The application service must have already had a license assigned to it
D. Correct The application service cannot have any licenses assigned to it

Additional Certification Support and Questions

Make sure you are familiar with our certification program guidelines BEFORE registering and taking the certification exam.

These include our Test Policy, price and NDA requirement.


Enroll Now

Print Friendly and PDF