exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 4 question 22 discussion

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

HOTSPOT -
You have an Azure Data Factory pipeline that has the activities shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: succeed -

Box 2: failed -
Example:
Now let's say we have a pipeline with 3 activities, where Activity1 has a success path to Activity2 and a failure path to Activity3. If Activity1 fails and Activity3 succeeds, the pipeline will fail. The presence of the success path alongside the failure path changes the outcome reported by the pipeline, even though the activity executions from the pipeline are the same as the previous scenario.

Activity1 fails, Activity2 is skipped, and Activity3 succeeds. The pipeline reports failure.
Reference:
https://datasavvy.me/2021/02/18/azure-data-factory-activity-failures-and-pipeline-outcomes/

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
ItHYMeRIsh
Highly Voted 3 years, 4 months ago
The answers are correct. The second question is "failed" because web1 has both a success and failed path. web1 would have to have only a failed path for the second question to be considered successful.
upvoted 48 times
Sr18
9 months, 3 weeks ago
This was on my test on 26-Jun with 930+ score, I chose Succeeded for both. Test it for first one I'm damn sure its succeed and for second one also kind of sure
upvoted 2 times
...
XiltroX
2 years, 4 months ago
The second answer should be "Succeeded". You are providing false information to other members. The reason why it is a success is because Set Variable 2 happened because of the failure of Web 1. Therefore, this red pipeline is deedmed a success.
upvoted 31 times
wanchihh
1 year, 6 months ago
You are incorrect. https://learn.microsoft.com/en-us/azure/data-factory/tutorial-pipeline-failure-error-handling#do-if-else-block
upvoted 6 times
...
y154707
1 year, 5 months ago
Yes, as Wanchihh mentions, you are wrong. Upper branch status are fail => skipped => skipped. According to the logic in the url below, this is deemed as a failed pipeline.
upvoted 2 times
Dusica
11 months, 3 weeks ago
where did you find skipped?
upvoted 1 times
...
...
...
Avi_Bdj
3 years ago
Second should also be succeeded.
upvoted 11 times
...
a03
3 years, 4 months ago
Agree. Second is "Fail" because Success connector presented.
upvoted 4 times
...
...
RajBathani
Highly Voted 3 years, 4 months ago
The second answer should be Succeeded as 'Set Variable 2' has failed dependency on Web1.
upvoted 39 times
...
20b1837
Most Recent 3 weeks, 6 days ago
The answer given is correct. Please take notice of the colour of the dependency from set variable to stored procedure.. It is on success, NOT skip dependency. This is a GOTCHA question. If you review the MS documentation the pattern shown that looks like this has a grey line (SKIP DEPENDENCY) which is different to this example. Only when skip dependency is used in a pattern like this would both examples be success.
upvoted 1 times
...
Karoubi
8 months, 1 week ago
both are succeded
upvoted 1 times
...
Kryor
8 months, 2 weeks ago
Both Succeed
upvoted 1 times
...
7082935
8 months, 2 weeks ago
The arrow between "Set Variable 1" and "Stored Procedure 1" is green which indicates a "succeed dependency". (a grey arrow indicates skipped). This means the pipeline will fail on answer 2 since Stored Procedure 1 will never execute.
upvoted 1 times
...
Dusica
11 months, 3 weeks ago
when PL has a success and fail path if any of those completes the PL is succeeded. So second is succeeded
upvoted 1 times
Dusica
11 months, 3 weeks ago
as of skip - it is used in debug mode
upvoted 1 times
...
...
Alongi
1 year ago
Both Success
upvoted 1 times
...
dakku987
1 year, 3 months ago
Both are success 100% sure about this
upvoted 1 times
...
dakku987
1 year, 3 months ago
I think both are successful bcz i think when web activity fail it will pass to the set variable and the purpose of the set varible will beCOMPLETED so pipeline will be success
upvoted 1 times
...
Abdulwahab1983
1 year, 4 months ago
Both should be succeed https://learn.microsoft.com/en-us/azure/data-factory/tutorial-pipeline-failure-error-handling#summary-table
upvoted 2 times
...
Abdulwahab1983
1 year, 5 months ago
Do If Skip Else block 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 1 times
...
kkk5566
1 year, 7 months ago
1. Success and 2. Failed
upvoted 2 times
...
chryckie
1 year, 11 months ago
The answer is correct! It's actually pretty neat how ADF determines that. If an activity fails but there was a subsequent OnSuccess activity that never runs, it's a fail. To handle that, you also need an OnSkipped activity to follow the OnSuccess activity in case it never ran! https://learn.microsoft.com/en-us/azure/data-factory/tutorial-pipeline-failure-error-handling#do-if-else-block
upvoted 12 times
Vanq69
1 year, 6 months ago
There are so many wrong high voted answers. READ THIS.
upvoted 3 times
...
JoannaMar
1 year, 6 months ago
Thanks @chryckie for this explanation. Finally it's clear!
upvoted 2 times
...
...
AHUI
2 years ago
second box should be succeeded https://learn.microsoft.com/en-us/azure/data-factory/tutorial-pipeline-failure-error-handling#do-if-skip-else-block
upvoted 4 times
...
vrodriguesp
2 years, 3 months ago
Using this microsfot doc: https://learn.microsoft.com/en-us/azure/data-factory/tutorial-pipeline-failure-error-handling#try-catch-block that claims ""We determine pipeline success and failures as follows: -)Evaluate outcome for all leaves activities. If a leaf activity was skipped, we evaluate its parent activity instead -)Pipeline result is success if and only if all nodes evaluated succeed"" I used this logic When web1 activity fails: node setVariable2 succeeds and setVariable1 is skipped and its parent node web1 failed; overall pipeline fails
upvoted 6 times
...
csd
2 years, 8 months ago
In any scenario pipeline will show success status, cause we are catching the failure
upvoted 2 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago