Informatica Exam PR000007 Topic 1 Question 100 Discussion

Actual exam question for Informatica's PR000007 exam

Question #: 100
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: A

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

by Theodora at Sep 18, 2024, 09:43 PM

Limited Time Offer

25%

Off

Get Premium PR000007 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Joaquin

6 days ago

I'm not sure, but I think option B) The transaction environment SQL executes just before a COMMIT against the target, could also be correct.

upvoted 0 times

...

Mari

6 days ago

I bet the person who wrote this question was feeling pretty Workflow-y when they came up with it.

upvoted 0 times

...

Laurena

11 days ago

I'm just hoping the exam doesn't ask me to draw a PowerCenter workflow from memory. That would be a real Connector-tration test!

upvoted 0 times

...

Xochitl

14 days ago

A sounds like it's describing the connection environment, but I'm not sure if that's the correct answer.

upvoted 0 times

...

Sylvia

23 days ago

C is a bit confusing. Why would the transaction environment SQL cause PowerCenter to ignore the Transaction Control Transformation?

upvoted 0 times

...

Angelyn

25 days ago

D seems interesting, but I'm not sure if you can use the connection environment SQL to set folder permissions in the repository.

upvoted 0 times

...

Thersa

26 days ago

I think the answer is B. The transaction environment SQL executes just before a COMMIT against the target database.

upvoted 0 times

Alyssa

21 days ago

B) The transaction environment SQL executes just before a COMMIT against the target.

upvoted 0 times

...

Katie

22 days ago

A) The connection environment SQL executes when a session connects to the database.

upvoted 0 times

...

Marti

26 days ago

I agree with Refugia, because the connection environment SQL is executed when the session connects to the database.

upvoted 0 times

...

Refugia

29 days ago

I think the correct answer is A) The connection environment SQL executes when a session connects to the database.

upvoted 0 times

...