exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 2 question 6 discussion

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

You have an Azure Data Factory instance that contains two pipelines named Pipeline1 and Pipeline2.
Pipeline1 has the activities shown in the following exhibit.

Pipeline2 has the activities shown in the following exhibit.

You execute Pipeline2, and Stored procedure1 in Pipeline1 fails.
What is the status of the pipeline runs?

  • A. Pipeline1 and Pipeline2 succeeded.
  • B. Pipeline1 and Pipeline2 failed.
  • C. Pipeline1 succeeded and Pipeline2 failed.
  • D. Pipeline1 failed and Pipeline2 succeeded.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
SaferSephy
Highly Voted 3 years, 7 months ago
Correct answer is A. The trick is the fact that pipeline 1 only has a Failure dependency between de activity's. In this situation this results in a Succeeded pipeline if the Stored procedure failed. If also the success connection was linked to a follow up activity, and the SP would fail, the pipeline would be indeed marked as failed. So A.
upvoted 51 times
BK10
3 years, 2 months ago
well explained! A is right
upvoted 1 times
...
Ram0202
1 year, 10 months ago
correct ,Execute pipeline explained here https://youtu.be/Jkz1dtLrBE4
upvoted 5 times
...
...
echerish
Highly Voted 3 years, 7 months ago
Pipeline 2 executes Pipeline 1 if success set variable. Since Pipeline 1 exists it's a success Pipeline 1 Stored procedure fails. If fails set variable. Since the expected outcome is fail the job runs successfully and sets variable1. At least that's how I understand it
upvoted 28 times
...
Danweo
Most Recent 9 months, 1 week ago
Selected Answer: A
A is correct
upvoted 1 times
...
moneytime
1 year, 2 months ago
I chose D There are two paths defined in the question. For pipeline1, upon failure For pipeline2; Upon success. Now ,for pipeline1, to respond to the run of pipeline 2 simply showed that they were connected. This is a case of Upon if else block condition. When previous activity (procedure)failed : node Upon Success is skipped and its parent node failed; overall pipeline1 failed When previous activity succeeds: node Upon Success succeeded and node Upon Failure is skipped (and its parent node succeeds); overall pipeline succeeds. Hence ,pipeline 2 succeeds The pipeline2 can be visualized as thus P2->P1
upvoted 1 times
...
kkk5566
1 year, 7 months ago
Selected Answer: A
Correct answer is A.
upvoted 1 times
...
azaspirant
1 year, 8 months ago
Selected Answer: B
How do we know which is the default behaviour? Its not mentioned anywhere wether there is a success dependency or failure dependency
upvoted 3 times
...
akhil5432
1 year, 8 months ago
Selected Answer: A
OPTION "A"
upvoted 1 times
...
joponlu
1 year, 10 months ago
Selected Answer: A
Correct!!!
upvoted 2 times
...
mamahani
1 year, 11 months ago
Selected Answer: A
A is correct answer
upvoted 2 times
...
Billybob0604
2 years, 4 months ago
So the default behaviour is Failed dependency ? If so the answer is A. But it doesn't say this anywhere in the question.
upvoted 1 times
...
NoobTester
2 years, 6 months ago
Answer is correct. This article helped: https://www.sqlshack.com/dependencies-in-azure-data-factory/
upvoted 1 times
...
Deeksha1234
2 years, 8 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
SebK
3 years ago
Selected Answer: A
Correct
upvoted 1 times
...
AngelJP
3 years, 1 month ago
Selected Answer: A
A correct: Pipeline 1 is in try catch sentence --> Success Pipeline 2 --> Success https://docs.microsoft.com/en-us/azure/data-factory/tutorial-pipeline-failure-error-handling#try-catch-block
upvoted 6 times
AvSUN
1 year, 7 months ago
Thanks
upvoted 1 times
...
...
PallaviPatel
3 years, 2 months ago
Selected Answer: A
A correct. I agree with SaferSephy's comments below.
upvoted 3 times
...
dev2dev
3 years, 3 months ago
A is correct. Pipeline 1 is connected to Set variable to Failure node/event. Its like handling exceptions/errors in programming language. Without Failure node, it would be treated as failed.
upvoted 2 times
...
VeroDon
3 years, 3 months ago
Selected Answer: A
Correct
upvoted 1 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