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
Activities are linked together via dependencies. A dependency has a condition of one of the following: Succeeded, Failed, Skipped, or Completed.
Consider Pipeline1:
If we have a pipeline with two activities where Activity2 has a failure dependency on Activity1, the pipeline will not fail just because Activity1 failed. If Activity1 fails and Activity2 succeeds, the pipeline will succeed. This scenario is treated as a try-catch block by Data Factory.
The failure dependency means this pipeline reports success.
Note:
If we have a pipeline containing Activity1 and Activity2, and Activity2 has a success dependency on Activity1, it will only execute if Activity1 is successful. In this scenario, if Activity1 fails, the pipeline will fail.
Reference:
https://datasavvy.me/category/azure-data-factory/
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.
well explained! A is right
correct ,Execute pipeline explained here https://youtu.be/Jkz1dtLrBE4
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
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
Thanks
A correct. I agree with SaferSephy's comments below.
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.
A is correct answer
Correct!!!
How do we know which is the default behaviour? Its not mentioned anywhere wether there is a success dependency or failure dependency
Correct
Correct
A is correct
Answer is correct. This article helped: https://www.sqlshack.com/dependencies-in-azure-data-factory/
So the default behaviour is Failed dependency ? If so the answer is A. But it doesn't say this anywhere in the question.
OPTION "A"
Correct answer is A.
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
A is correct