PowerCenter Data Integration 10 Administrator, Professional Certification
Certification Exam | Data Integration | Version 10 | 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 :
- 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 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):
- PowerCenter: Administration Fundamentals (Instructor Led or onDemand)
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
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
|
Deployment
|
|---|
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.
