Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Informatica
  5. PR000007

Informatica PR000007 Exam
PowerCenter Data Integration 9.x Administrator Specialist (Page 2 )

Updated On: 12-Jan-2026
Page 2 of 15
PDF with 70 Questions

Which of the following services does not require a database connection as part of its configuration?

  1. The Powercenter Repository service.
  2. The Powercenter Integration Service.
  3. The PowerCenter Designer Service.
  4. The Reporting Service.

Answer(s): C


Reference:

https://docs.oracle.com/cd/E35287_01/bia.7964/e35271/windows_ic.htm#BABCAJGA



In reference to relational connections created in the PowerCenter Workflow Manager, which one of the following statements is true?

  1. The connection environment SQL executes when a session connects to the database.
  2. The transaction environment SQL executes Just before a COMMIT against the target.
  3. The transaction environment SQL causes PowerCenter to ignore the Transaction Control Transformation.
  4. You can use the connection environment SQL to set folder permissions in the PowerCenter repository database.

Answer(s): A


Reference:

http://www.info-etl.com/course-materials/tips-power-center-9



Pmcmd is used for which of the following tasks?

  1. Delete workflow, schedule workflow, ping service.
  2. Start workflow, schedule workflow, ping service.
  3. Start workflow, delete task, ping service.
  4. Start workflow, schedule workflow, copy workflow.

Answer(s): B


Reference:

http://www.folkstalk.com/2012/10/pmcmd-command-usage-in-informatica.html



Why would a repository service be placed in Exclusive mode?

  1. If the repository service will be the only service running on a node.
  2. If the repository service is not to be configured to run in backup mode.
  3. In order to change a property of the repository service.
  4. If it is desired to prevent the repository service from running as part of a grid.

Answer(s): C



In Informatics 9.x, which is true about domain configuration backup using the infasetup command line program'?

  1. It Backs up the domain database and all service databases that are part of that domain.
  2. It backs up domain metadata to another domain database.
  3. It backs up the domain configuration to a binary file.
  4. It backs up the domain to two binary files, one of which holds an index and the other the data.

Answer(s): C


Reference:

http://www.bianalyticschannel.com/2013/12/09/how-to-migrate-informatica-repositories- to-another-database/



Viewing page 2 of 15
Viewing questions 6 - 10 out of 70 questions



Post your Comments and Discuss Informatica PR000007 exam prep with other Community members:

Join the PR000007 Discussion