Ensuring Azure Synapse Pipeline Success with Set Variable
Short answer
B a skipped dependency on the Upon Success activity
Question
Key Takeaways
Tests knowledge of error handling patterns in ADF/Synapse pipelines, specifically how unhandled failure branches cause overall pipeline failure unless resolved.
Configure a skipped dependency on the 'Upon Success' activity to guarantee pipeline success. Community consensus confirms this pattern handles errors gracefully by ensuring at least one successful terminal activity exists.
Common mistake: Option D is often chosen because it seems intuitive to handle failures directly; however, without a corresponding success path or handled termination, the pipeline may still report failure if the error branch isn't fully consumed by a success outcome.
Expert Analysis
Why the Answer Is Correct
Adding a 'Skipped' dependency from the 'Upon Failure' activity to the 'Set Variable' (or any final activity) ensures that even if the main logic fails and triggers the error path, the execution flow continues to a terminal activity that can be configured to succeed. This effectively masks the internal business logic failure from the pipeline's overall status view.
Why the Other Options Are Wrong
Option A suggests skipping the success path, which doesn't help if the failure path is taken. Option C implies a hard dependency on a failing activity, which would propagate failure. Option D handles the failure but might leave the pipeline in a failed state if no subsequent success-oriented terminal activity is reached or configured properly.
Community Comment Notes
Comment [4] highlights a critical nuance: simply having an 'Upon Failure' path isn't enough; you must ensure the final leaf activity succeeds. Comments [2] and [3] reinforce that attaching a skipped dependency to the success path (or ensuring the error path leads to a success) guarantees the pipeline returns a 'Succeeded' status.
Official Reference
https://learn.microsoft.com/es-es/azure/data-factory/tutorial-pipeline-failure-error-handling
This link opens the official vendor documentation in a new tab.
Community Votes
100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 5 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 5
-
[Removed] 👍 5 Answered BCorrect. https://learn.microsoft.com/es-es/azure/data-factory/tutorial-pipeline-failure-error-handling
-
Azure_2023 👍 4 Answered BIn this approach, customer defines the business logic, and defines both the Upon Failure path, and Upon Success path, with a dummy Upon Skipped activity attached. This approach renders pipeline succeeds, if Upon Failure path succeeds.
-
jongert 👍 3 Answered BShould be B, creating an 'Do If Skip Else' statement by adding a skipped dependency to the success path means that the pipeline is always succeeded.
-
AlbertoSoriano 👍 1 Answered BTo me the answer is not complete. If only a Skipped dependency on "Upon Success" is used, the pipeline may still fail if "Upon Failure" is an unhandled terminal activity. Since ADF determines the pipeline’s final status based on all unhandled leaf activities, adding a Completion dependency on "Upon Failure" ensures that a final successfully executed activity is present, guaranteeing that the pipeline always ends in Success. I guess B is the most accurate but not completely correct.
-
Tapaskaro 👍 5Answer B, tested in ADF
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.