DP-700 Ingest and Transform Data Practice Question
Which Fabric feature allows you to orchestrate complex data ingestion and transformation workflows using a drag-and-drop interface?
⚠ Common exam trap
Candidates confuse Data Pipelines with Dataflows or Notebooks, missing that orchestration of multiple end-to-end tasks via a drag-and-drop interface is specifically handled by Data Pipelines.
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
✓
Data Pipeline
Data Factory pipelines in Fabric provide a powerful, low-code interface for orchestrating end-to-end data integration. By dragging and dropping activities such as Copy, Notebook, and Dataflow, engineers can build robust, repeatable workflows. This feature is fundamental for simplifying the management of complex data pipelines, allowing teams to focus on logic and flow rather than writing extensive custom code for orchestration and scheduling.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
KQL Queryset
Why it's wrong here
KQL Querysets are used for running analytical queries against KQL databases. They are designed for data exploration and reporting, not for orchestrating ETL pipelines. Confusing query tools with orchestration tools leads to incorrect architecture, as KQL Querysets lack the control flow features like loops or conditionals.
- ✓
Data Pipeline
Why this is correct
Data Pipeline is the primary orchestration service in Microsoft Fabric. It offers a visual canvas to build data-driven workflows, manage dependencies, and monitor execution. It is specifically designed to handle the orchestration of complex ingestion and transformation tasks across diverse data sources and destinations.
- ✗
Power BI Report
Why it's wrong here
Power BI is a data visualization tool. While it consumes data created by pipelines, it does not provide any orchestration capabilities for ETL tasks. Trying to use Power BI for pipeline orchestration is an incorrect application that fails to provide necessary features like scheduling or retry logic.
- ✗
Mirroring
Why it's wrong here
Mirroring is a feature to replicate data from operational databases into Fabric with minimal effort. It is not an orchestration engine for general-purpose pipelines. While useful for simple synchronization, it lacks the flexibility to perform multi-step transformations, conditional branching, and complex workflow management required for enterprise data integration.
About these practice questions
One of 152 original DP-700 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.