In Reference to Relational Connections Created in the PowerCenter Workflow

question 39

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.

---

Definitions:

Normal Probability Distribution

A bell-shaped curve that is symmetric about the mean, describing how the values of a variable are distributed, indicating most data falls close to the mean.

Sampling Distribution

The probability distribution of a given random-sample-based statistic.

Sample Sizes

Refers to the different quantities or numbers of observations collected from populations for various studies.

Standard Error

A measure of the statistical accuracy of an estimate, computed from the standard deviation of the sampling distribution of a statistic.