DP-700 Ingest and Transform Data Practice Question
You are building a pipeline and need to ensure that a downstream activity only runs if a previous activity succeeds. Which pipeline feature should you use?
⚠ Common exam trap
Candidates often confuse 'On Success' with 'On Completion' or 'On Failure'. 'On Completion' triggers regardless of success, which is not the same as ensuring a dependency only runs after success.
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
✓
An 'On Success' connector
The 'On Success' constraint on the pipeline connector links two activities in a dependency chain. This ensures that the second activity starts only if the first one finishes without errors. This is fundamental for building reliable, production-grade workflows where the order of operations and the integrity of the data processing chain are paramount for successful data delivery to the end users.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A ForEach activity
Why it's wrong here
The ForEach activity is used for looping through a collection of items. It is not designed to handle workflow dependencies or control the execution flow based on the success or failure of a specific preceding activity in the pipeline.
- ✓
An 'On Success' connector
Why this is correct
The 'On Success' connector is the explicit feature in Fabric pipelines used to define a dependency that triggers the next activity only after the successful completion of the previous activity. It is the standard way to chain activities and ensure a valid execution sequence.
- ✗
A Wait activity
Why it's wrong here
The Wait activity is used to pause the pipeline for a specified period of time. It does not provide any logic for conditional execution based on the success or failure of previous activities, nor does it control the flow of execution between steps.
- ✗
A Filter activity
Why it's wrong here
The Filter activity is used to narrow down the data being processed. It has no role in orchestrating the pipeline control flow or creating conditional dependencies between different activities. It operates on the data payload, not the pipeline execution state.
About these practice questions
This DP-700 question is part of Courseiva's 152-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.