DP-203 Practice Question: Secure, monitor, and optimize data storage and data processing
You are designing a data pipeline using Azure Synapse Pipelines. The pipeline ingests data from multiple sources, performs transformations using a notebook, and loads the results into a dedicated SQL pool. You need to ensure that if the notebook fails, the entire pipeline stops and sends an alert. What is the most efficient way to configure this?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Add a 'Fail' activity after the notebook activity and connect the notebook's failure output to it. Configure the Fail activity to send an alert.
The most efficient: In Azure Synapse Pipelines (and Azure Data Factory), you can connect the failure output of the notebook activity to a 'Fail' activity. The Fail activity can be configured to send an alert (e.g., via webhook) and it stops the pipeline run immediately. Option A is incorrect because setting a wildcard error path would allow other activities to run; instead, you should explicitly route the failure to a Fail activity. Option B is incorrect because setting retry to 0 only prevents retries, but does not automatically stop the pipeline or send an alert. Option D is incorrect because the default behavior of a failed activity is to continue pipeline execution along the default error path, not to stop entirely; you must define an explicit failure path.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Set the notebook activity's error path to a webhook activity that sends an alert, and then set a wildcard error path for the pipeline.
Why it's wrong here
Incorrect: A wildcard error path would catch errors from any activity but does not stop the pipeline; other activities may still run.
- ✗
Set the notebook activity's retry count to 0, and configure an alert on the pipeline run failure.
Why it's wrong here
Incorrect: Even with retry 0, the pipeline continues to subsequent activities unless a failure path is explicitly set.
- ✓
Add a 'Fail' activity after the notebook activity and connect the notebook's failure output to it. Configure the Fail activity to send an alert.
Why this is correct
Correct: The Fail activity terminates the pipeline with an error, and you can trigger alerts based on pipeline failure.
- ✗
No configuration needed; by default, a failed activity stops the entire pipeline.
Why it's wrong here
Incorrect: By default, a failed activity does not stop the pipeline; subsequent activities run unless dependencies are configured.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DP-203 question from scratch — 760 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-203 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-203 exam.