Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 — Question 16

In your ETL process, there are three external processes that need to be executed in sequence, but you do not want to stop execution if any of them fails.
Can this be achieved by using precedence constraints? If so, which precedence constraints can be used?

Answer options

• A. No, this cannot be achieved just by using precedence constraints.
• B. Yes, this can be achieved by using completion precedence constraints between the first and the second and between the second and the third Execute Process tasks, and by using a success precedence constraint between the third Execute Process task and the following task.
• C. Yes, this can be achieved by using completion precedence constraints between the first and the second, between the second and the third, and between the third Execute Process task and the following task.
• D. Yes, this can be achieved by using failure precedence constraints between the first and the second, and between the second and the third Execute Process

Correct answer: B

Explanation

The correct answer is B because using completion precedence constraints allows the tasks to proceed even if one fails, while a success precedence constraint ensures that the next step only executes if the last task succeeds. Options A and D are incorrect because they either deny the possibility or suggest using failure constraints, which would halt the execution on failure. Option C is wrong as it implies a success constraint on the last task, which is not aligned with the requirement of not stopping on failures.