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

9 months 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

9 months ago

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

upvoted 0 times

...

Laurena

9 months 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

Aleisha

8 months ago

D) You can use the connection environment SQL to set folder permissions in the PowerCenter repository database.

upvoted 0 times

...

Shenika

8 months ago

C) The transaction environment SQL causes PowerCenter to ignore the Transaction Control Transformation.

upvoted 0 times

...

Xuan

8 months ago

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

upvoted 0 times

...

Levi

8 months ago

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

upvoted 0 times

...

Xochitl

9 months ago

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

upvoted 0 times

Son

8 months ago

C) The transaction environment SQL causes PowerCenter to ignore the Transaction Control Transformation.

upvoted 0 times

...

Arlie

8 months ago

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

upvoted 0 times

...

Rikki

8 months ago

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

upvoted 0 times

...

Sylvia

9 months ago

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

upvoted 0 times

Dean

8 months ago

D) You can use the connection environment SQL to set folder permissions in the PowerCenter repository database.

upvoted 0 times

...

Candida

8 months ago

C) I think it's because the transaction environment SQL overrides the Transaction Control Transformation.

upvoted 0 times

...

Graciela

8 months ago

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

upvoted 0 times

...

Janey

8 months ago

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

upvoted 0 times

...

Angelyn

9 months 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

9 months ago

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

upvoted 0 times

Alyssa

9 months ago

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

upvoted 0 times

...

Katie

9 months ago

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

upvoted 0 times

...

Marti

9 months ago

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

upvoted 0 times

...

Refugia

9 months ago

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

upvoted 0 times

...