In Reference to Relational Connections Created in the PowerCenter Workflow

Multiple Choice

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

A) The connection environment SQL executes when a session connects to the database.
B) The transaction environment SQL executes Just before a COMMIT against the target.
C) The transaction environment SQL causes PowerCenter to ignore the Transaction Control Transformation.
D) You can use the connection environment SQL to set folder permissions in the PowerCenter repository database.