DP-700 Implement and Manage an Analytics Solution Practice Question
You are designing a data orchestration strategy using Microsoft Fabric Data Factory. You need to ensure that your pipeline can handle intermittent source system failures and provide notifications upon success or failure. Which THREE pipeline activities or features should you use? (Choose THREE)
⚠ Common exam trap
Candidates often confuse the 'Until' activity with 'Retry' policy settings, or incorrectly assume that custom notification activities are built-in features rather than needing an external Outlook or Teams connector.
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
✓
Retry policy settings on the Copy activity.
Data Factory pipelines in Fabric offer several control flow and notification activities to build resilient data movements. Using Retry policies helps handle transient errors, while 'Until' or 'If Condition' activities manage logic, and Office 365 Outlook activities facilitate communication. These features are vital for creating production-ready pipelines that can recover from errors and keep stakeholders informed of the processing status.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Retry policy settings on the Copy activity.
Why this is correct
Retry policies allow a pipeline to automatically attempt an activity again if it fails due to transient issues, such as network timeouts. By configuring the number of retries and the interval between them, engineers can build more resilient workflows that don't require manual intervention for minor glitches. This is a standard best practice for managing unreliable source systems in cloud environments.
- ✓
The Office 365 Outlook activity.
Why this is correct
The Office 365 Outlook activity enables pipelines to send automated email notifications based on the outcome of previous steps. This is essential for alerting administrators to failures or confirming the successful completion of critical data loads. Integrating communication directly into the orchestration flow ensures that the operations team remains updated on the health of the analytics solution.
- ✗
The 'Wait' activity for fixed delays.
Why it's wrong here
While the Wait activity pauses the pipeline execution for a specified duration, it does not provide logic for handling failures or sending notifications. It is generally used for timing-related dependencies rather than error recovery or status reporting. Overusing Wait activities can also lead to inefficient resource utilization and longer overall pipeline durations without adding significant resilience.
- ✓
Success and Failure constraints (On Success / On Failure).
Why this is correct
Constraints allow developers to define different execution paths based on whether an activity succeeded or failed. This logic is crucial for triggering cleanup tasks or error-logging activities specifically when something goes wrong. By branching the pipeline logic, you can ensure that notifications are only sent under the appropriate conditions, improving the clarity of the orchestration process.
- ✗
The 'Stored Procedure' activity to update OneLake metadata.
Why it's wrong here
Stored Procedure activities are used to execute SQL code in a Warehouse or SQL database, but they are not the primary tool for handling source system resilience or sending notifications. While they can be part of a data flow, they do not natively provide the notification or retry logic requested in the scenario. They are compute-specific rather than orchestration-specific features.
About these practice questions
Courseiva writes every DP-700 question from scratch — 152 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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This DP-700 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-700 exam.