Try Free Informatica PR000007 ICP Updated Questions & Answers

Question 1

Which statement best describes the process when a user connects to a PowerCenter Repository Service for the first time?

Assume the following:

-PowerCenter Developer is the only PowerCenter client application running -There are 2 nodes in the domain, node 1 is a gateway node and node 2 is a worker node -The PowerCenter Repository Service is running on the worker node

AThe user connects directly and immediately to the Repository service.

BThe user connects to the service manager of the gateway node, and after authentication and authorization, is reassigned to the Repository Service.

CThe user connects to the service manager of the worker node that is running the Repository service, is then authenticated, authorized, and connected to the PowerCenter Repository service.

DThe user first connects to the PowerCenter Integration Service and then after authentication and authorization, is connected to the PowerCenter Repository Service.

Correct answer: C

Question 2

The Service Manager runs which functions on the Master Gateway Node in the domain?

AWorkflows, Configuration, and Alerting.

BSecurity, Web Services, and Alerting.

CSecurity, Configuration, and Alerting.

DWeb Services, Configuration, and Licensing.

Correct answer: D

https://www.scribd.com/doc/60458347/In-90-Administrator-Guide#download(page 27)

Question 3

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

AThe connection environment SQL executes when a session connects to the database.

BThe transaction environment SQL executes Just before a COMMIT against the target.

CThe transaction environment SQL causes PowerCenter to ignore the Transaction Control Transformation.

DYou can use the connection environment SQL to set folder permissions in the PowerCenter repository database.

Correct answer: A

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

Question 4

When creating a new repository service, a database username (schema) must be specified to hold the metadata tables

Can the new repository service use a database schema that contains existing repository tables and objects? Assume you need to preserve the existing objects.

ANo. For a new repository service, the database schema must be empty.

BNo. When the new service is created, existing tables will be automatically dropped.

CYes. The tables and objects will be preserved by default.

DYes. The user must select the creation option, 'Do not create new content.

Correct answer: C

Question 5

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

AThe Powercenter Repository service.

BThe Powercenter Integration Service.

CThe PowerCenter Designer Service.

DThe Reporting Service.

Correct answer: C

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

PR000007 Exam Dumps and Practice Questions

Most Recent Informatica PR000007 Exam Dumps

Actual Informatica PR000007 Exam Questions

Unlock all Informatica PR000007 questions