70-463 · Question #220
70-463 Question #220: Real Exam Question with Answer & Explanation
The correct answer is B: Yes, this can be achieved by using completion precedence constraints between the first and. Precedence constraints in SSIS control the execution order and conditions between control flow tasks. There are three types: Success (next task runs only if the previous succeeded), Failure (next task runs only if the previous failed), and Completion (next task runs regardless of
Question
Options
- ANo, this cannot be achieved just by using precedence constraints.
- BYes, this can be achieved by using completion precedence constraints between the first and
- CYes, this can be achieved by using completion precedence constraints between the first and
- DYes, this can be achieved by using failure precedence constraints between the first and the
Explanation
Precedence constraints in SSIS control the execution order and conditions between control flow tasks. There are three types: Success (next task runs only if the previous succeeded), Failure (next task runs only if the previous failed), and Completion (next task runs regardless of whether the previous task succeeded or failed). To run three external processes in sequence without stopping if any one fails, you use Completion precedence constraints between all three tasks. This guarantees the second task always runs after the first, and the third always runs after the second, regardless of their individual outcomes. Option B correctly identifies Completion constraints between all three tasks.
Community Discussion
No community discussion yet for this question.