Question 1

PowerCenter Web Service Hubs use which one of the following?

Accepted Answer

A)   The SOAP standard and a fixed XML data structure to receive requests and send responses to web service clients.
B)   The RPC (Remote Procedure Call)  standard to receive requests and send responses to web service clients.
C)   The soap standard to receive requests and send responses to web service clients.
D)   The rpc (Remote Procedure call)  standard and a fixed XML data structure to receive requests and send ' ^responses to web service clients. C

Question 2

Which is a type of connection object you can create with PowerCenter?

Accepted Answer

A)   FTP
B)   TCP/IP
C)   Partitioned
D)   Dynamic database A

Question 3

What is the purpose of operating system profiles?

Accepted Answer

A)   To allow two or more workflows to run on the same node under different operating system users.
B)   To allow two or more Integration Services to run on the same node under differed operating system users.
C)   To allow two or more workflows to run on the same node while accessing different database connection users.
D)   To allow two or more Integration Services to run a single workflow on two or more different nodes with different operating systems. D

Question 4

Which of the following is true about PowerCenter Repositories and Integration Services?

Accepted Answer

A)   An Integration Service may be connected to more than one Repository Service.
B)   An Integration Service may be connected to only one Repository Service.
C)   Repository Service is a client of an Integration Service.
D)   A Repository Service may be connected to more than one Integration Service and an Integration Service may be connected to more than one Repository Service.

Question 5

What needs to be done to inherit domain privileges''

Accepted Answer

A)   Use domain folders.
B)   Use domain groups.
C)   Set the privileges on a set-vice level.
D)   Set the privileges on a service or group level.

Question 6

Which step(s) must be followed to make a copy of the PowerCenter repository metadata? Assume that the source repository is in a separate domain from the new repository.

Accepted Answer

A)   Backup the source repository to a file 2. Create a Repository Service for the new repository that has no tables 3. Restore the backup file to the new repository
B)   Backup the source repository to a file 2. Create a Repository Service for the new repository that has tables 3. Restore the backup file to the new repository
C)   Use the "Copy Contents" feature in the Administrator Tool
D)   Create a Repository Service for the new repository that has no tables 2. In the Repository Manager Tool, click and drag the source repository to the new repository

Question 7

Which object below can be imported into a domain from LDAP?

Accepted Answer

A)   Permissions
B)   Privileges
C)   Groups
D)   Roles

Question 8

Which command line tool is used to create Informatica user accounts?

Accepted Answer

A)   pmcep
B)   infacmd
C)   infasetup
D)   pmcmd

Question 9

When is it advisable to migrate PowerCenter repository objects between domains using the XML export-import method?

Accepted Answer

A)   When the master gateway node on the domains are running on different operating systems.
B)   When the domain databases are in different database types (Oracle and Sybase, for example) .
C)   When the PowerCenter Repository Manager cannot access the repositories in both domains at the same time.
D)   When the license key for Team Based Development - Deployment Groups is not available.

Question 10

A customer has purchased license keys for nodes running both the Windows and UNIX operating systems Can they run one Windows node and one UNIX node?

Accepted Answer

A)   Yes provided the nodes are in different domains.
B)   Yes, if both nodes are within the same domain.
C)   Yes, but this arrangement requires a PowerCenter Grid license to be activated.
D)   Yes, but a primary service on one of the nodes cannot be configured to run as a backup service on the other node.

Question 11

What is the purpose of a Repository Service?

Accepted Answer

A)   To run PowerCenter Workflows.
B)   To run and schedule PowerCenter workflows, validate mappings.
C)   To manage PowerCenter, Data Quality and Web Services metadata objects.
D)   To manage PowerCenter metadata objects.

Question 12

Where does Informatica 9.1 store encrypted passwords?

Accepted Answer

A)   Domain Configuration database
B)   PowerCenter Repository database
C)   Domain Security database
D)   Service Manager Repository

Question 13

Pmcmd is used for which of the following tasks?

Accepted Answer

A)   Delete workflow, schedule workflow, ping service.
B)   Start workflow, schedule workflow, ping service.
C)   Start workflow, delete task, ping service.
D)   Start workflow, schedule workflow, copy workflow.

Question 14

With respect to license keys used in the Informatica domain, choose the response below that is correct

Accepted Answer

A)   Each license key object can have only one license key.
B)   Each license key object can have multiple license keys.
C)   Each service can be associated with multiple license keys.
D)   One license key object is used for the domain, and it can have multiple keys associated with it.

Question 15

Which of the following statements is true about running a PowerCenter workflow?

Accepted Answer

A)   The Data Transformation Manager (DTM)  process starts and locks the workflow and runs the workflow tasks.
B)   The PowerCenter Integration Service process starts and locks the workflow and runs the workflow tasks.
C)   The Data Transformation Manager (DTM)  process starts the PowerCenter Integration Service process to run each Session and Command task within a workflow.
D)   PowerCenter Invokes the Data Transformation Manager (DTM)  only when the developer saves a mapping.

Question 16

When creating a repository folder what does the Allow Shortcut option provide?

Accepted Answer

A)   Objects in the folder can be created more quickly.
B)   Metadata shortcuts will be allowed within this folder.
C)   Metadata shortcuts will be allowed across repositories even if they are not in the same repository domain.
D)   Shortcuts created in other folders may reference metadata from this folder.

Question 17

When copying and replacing folders in PowerCenter version 9.10 , which of the following statements is true?

Accepted Answer

A)   The move is performed in two steps. The first step involves copying the source folder contents Into temp tables. At this point the target repository is in a read-only mode. The second step involves moving the information from the temp tables into the target folder. During this step the repository is locked.
B)   The move is performed in one step. This involves copying the source folder contents into the target folder. During this step the repository is locked.
C)   The move is performed in two steps. The first step involves copying the source folder contents into XML files. The second step involves importing the XML files into the target folder. During this step the repository is locked.
D)   The Source Folder is copied Into the target folder. No locks are placed on the target repository.

Question 18

You can create PowerCenter connection objects within which client tool(s)?

Accepted Answer

A)   Workflow Manager
B)   Workflow Manager or Workflow Monitor
C)   Workflow Manager or Repository Manager
D)   Repository Manager or Informatica Administrator

Question 19

You are migrating a domain to a new domain database. What is the correct order of the next actions to complete the migration once the new domain database is successfully restored?

Accepted Answer

A)   Start all nodes, update database configuration on each node, enable application services.
B)   Update database configuration on each node, start all nodes, enable application services.
C)   Enable application services, start all nodes, update database configuration on each node.
D)   Start all nodes, enable application services, update database configuration on each node.

Question 20

How many different repository services can be associated with a single integration service?

Accepted Answer

A)   One
B)   One or more
C)   Zero or more
D)   One if the integration service is not part of a grid, more than one if It is part of a grid

Exam 2: PowerCenter Data Integration 9.x Administrator Specialist