ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 2 question 122 discussion

Actual exam question from Microsoft's DP-203
Question #: 122
Topic #: 2
[All DP-203 Questions]

You have the Azure Synapse Analytics pipeline shown in the following exhibit.



You need to add a set variable activity to the pipeline to ensure that after the pipeline’s completion, the status of the pipeline is always successful.

What should you configure for the set variable activity?

  • A. a skipped dependency on the Upon Failure activity
  • B. a skipped dependency on the Upon Success activity
  • C. a success dependency on the Business Activity That Fails activity
  • D. a failure dependency on the Upon Failure activity
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by jongert at Jan. 6, 2024, 3:01 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Tapaskaro
Highly Voted 9 months, 2 weeks ago
Answer B, tested in ADF
upvoted 5 times
...
[Removed]
Highly Voted 9 months, 2 weeks ago
Selected Answer: B
Correct. https://learn.microsoft.com/es-es/azure/data-factory/tutorial-pipeline-failure-error-handling
upvoted 5 times
...
AlbertoSoriano
Most Recent 2 months, 3 weeks ago
Selected Answer: B
To 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.
upvoted 1 times
...
Azure_2023
8 months, 2 weeks ago
Selected Answer: B
In 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.
upvoted 4 times
MBRSDG
6 months, 4 weeks ago
for sure the correct answer. directly from docs --> https://learn.microsoft.com/en-us/azure/data-factory/tutorial-pipeline-failure-error-handling#do-if-skip-else-block
upvoted 1 times
...
...
jongert
9 months, 3 weeks ago
Selected Answer: B
Should 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.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago