Informatica pr000007 practice test

PowerCenter Data Integration 9.x Administrator Specialist Exam


Question 1

Complete the following sentence A process variable root directory is associated with a _?

  • A. Node
  • B. Integration service
  • C. Repository service
  • D. Domain
Answer:

C

Discussions

Question 2

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

  • 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.
Answer:

B

Discussions

Question 3

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.

  • 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
Answer:

A

Discussions

Question 4

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

  • A. pmcep
  • B. infacmd
  • C. infasetup
  • D. pmcmd
Answer:

B

Explanation:
Reference:
http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/createuser-group-
grant-permissions-5048100

Discussions

Question 5

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

  • 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.
Answer:

B

Explanation:
Reference:
http://addarr.me/2013/01/02/integration-service-architecture-informatica/

Discussions

Question 6

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

  • A. Workflow Manager
  • B. Workflow Manager or Workflow Monitor
  • C. Workflow Manager or Repository Manager
  • D. Repository Manager or Informatica Administrator
Answer:

A

Explanation:
Reference:
http://www.bispsolutions.com/bisp/web/pdf/freeTutorials/16_127751181-InformaticaWorking-
With-Repository.pdf(page 16)

Discussions

Question 7

Which is the best PowerCenter client application to use to copy a workflow into an empty folder in a
different repository?

  • A. The Workflow Manager, because the destination folder is empty.
  • B. The Workflow Manager, because only one workflow is to be transferred.
  • C. The Repository Manager, because It is the only client application that can transfer objects between repositories.
  • D. The Repository Manager, because it will automatically associate the correct mapping with the sessions in the workflow.
Answer:

A

Explanation:
Reference:
http://www.itap.purdue.edu/ea/files/PMPC62_release%20notes%20for%206.2.pdf(page 6)

Discussions

Question 8

PowerCenter Web Service Hubs use which one of the following?

  • 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.
Answer:

C

Explanation:
Reference:
http://gerardnico.com/wiki/powercenter/web_services_hub

Discussions

Question 9

Which of the following statements is true in reference to License Keys?

  • A. A license key may be assigned to a Repository Service running in normal mode.
  • B. A license key may be assigned to a Repository Service running in exclusive mode.
  • C. A license key may be assigned to a Repository Service that is disabled
  • D. A license key may only be assigned to a service at install time.
Answer:

A

Explanation:
Reference:
http://www.disoln.org/2012/09/Informatica-PowerCenter-9-Installation-andConfiguration-Complete-Guide.html

Discussions

Question 10

You need to create 60 Informatica Domain users.
You wish to assign them the same privileges without having to specify the privileges for each
individual user.
What is your recommended approach?

  • A. Place all the users in the same domain folder and set privileges on the folder.
  • B. Place all the users in the same group and set privileges on the group.
  • C. Create a role with the desired privileges and grant each user that role.
  • D. Use LDAP In conjunction with a domain folder organized with the desired privileges.
Answer:

D

Discussions
To page 2