A00-260 practice question 11 of 15

Which statement regarding propagation is FALSE?

Full set: 70 questions
Answer options
A: Automatic propagation can be set globally, so every new job will automatically propagate. Correct answer
B: Propagation can only occur in the direction of the job flow diagram (from beginning to end). Propagation from the end to the beginning is not available.
C: Automatic propagation that is set globally can be overridden and disabled within a job.
D: Automatic propagation that is set globally or at the job level can be overridden and disabled for a selected transformation.
Correct Answer:
A. Automatic propagation can be set globally, so every new job will automatically propagate.
Explanation

Statement A is false because of the absolute term "every". While a global setting for automatic propagation exists and applies to new, blank jobs, it does not apply to all possible new jobs. If a new job is created from a custom template, it inherits the properties set within that template. If the template has automatic propagation disabled, the new job created from it will also have it disabled, regardless of the global setting. This provides a clear counterexample to the claim that every new job will inherit the global setting.

Why Incorrect

B. This statement is true. Column propagation is fundamentally a unidirectional process that follows the data flow from source transformations (beginning) to target transformations (end). There is no feature for upstream or reverse propagation.
C. This statement is true. The properties of an individual job include a setting for propagation that can be set to "Enable," "Disable," or "Use global setting," allowing the global default to be overridden at the job level.
D. This statement is true. For granular control, the properties of each transformation within a job also have a propagation setting that can override the job-level (and thus the global) setting for that specific step.

References

1. SAS® Data Integration Studio 4.9: User's Guide, Chapter 4, "Working with Jobs", section "Creating a Job from a Template".

This section states: "When you create a job from a template, the new job has the same transformations, process flows, and properties as the template." This supports the reasoning that a template's properties override the global defaults for a new job, making statement A false.

2. SAS® Data Integration Studio 4.9: User's Guide, Chapter 11, "Working with Columns in a Job", section "About Column Propagation".

This section defines propagation: "Column propagation is the process of passing column metadata from one transformation in a job to the next transformation in the job." This confirms the unidirectional flow described in statement B.

3. SAS® Data Integration Studio 4.9: User's Guide, Chapter 11, "Working with Columns in a Job", sections "Setting Propagation Options for a Job" and "Setting Propagation Options for a Transformation".

These sections explicitly describe the user interface and functionality for overriding propagation settings at both the job level (confirming statement C) and the individual transformation level (confirming statement D).

Scroll to Top