DP-700 - Implement and Manage an Analytics Solution (34% of the exam) - Section 1.6

Choose between a Dataflow Gen2, a Data Factory pipeline, and a notebook to orchestrate a process.

Compare Dataflows Gen2, Data Factory pipelines, and notebooks across axes of transformation complexity, reuse, and capacity cost. Choose the right orchestration tool by matching low-code Power Query, the Copy activity, or PySpark to the requirements of a given process.

Dataflows Gen2 versus pipelines versus notebookslow-code versus code-first orchestrationtransformation complexity and reusecost and capacity considerationsCopy activity versus Spark

Practice question for this objective

Free sampleImplement and Manage an Analytics Solutionhard

A Microsoft Fabric process must run four steps every morning in a fixed order: copy files from a source, run a Dataflow Gen2 that curates them, run a notebook that builds aggregates only after the dataflow succeeds, and send a failure alert if any step fails. The team currently triggers each artefact on its own schedule a few minutes apart and finds the notebook sometimes starts while the dataflow is still running. Which change best gives true dependency-aware ordering with retries and alerts across all four steps?

  • AStagger the four independent schedules further apart so each artefact has more time to finish before the next one is triggered, reducing the chance of an early start.
  • BCombine the copy, curation, and aggregation into one large Spark notebook whose cells run top to bottom, so cell order enforces the dependency and a final cell sends the alert.
  • CExpand the Dataflow Gen2 so its Power Query graph performs the copy, the curation, and the aggregation in one refresh, then add a separate alert dataflow for failures.
  • DBuild a Data Factory pipeline that chains a Copy activity, a Dataflow activity, and a Notebook activity with on-success dependencies, activity retries, a schedule trigger, and a failure notification. Correct
Use a Data Factory pipeline to orchestrate ordered, dependency-aware execution across a Copy, a Dataflow Gen2, and a notebook with retries and alerts. Coordinating several distinct artefacts in a fixed order with success dependencies, retries, scheduling, and failure alerts is control-flow work, which is the purpose of a Data Factory pipeline; spaced schedules do not enforce success dependencies, and a single notebook or dataflow transforms data but cannot coordinate the other artefacts.

Why A is wrong: Wider time gaps still do not wait for a step to actually succeed; a slow or failed dataflow lets the notebook start anyway, so this gives no real dependency control, retries, or built-in alerting.

Why B is wrong: A notebook can sequence its own cells but cannot natively invoke the separate Dataflow Gen2 with managed retries and per-step failure alerts across distinct artefacts, so it is the wrong orchestration surface here.

Why C is wrong: A Dataflow Gen2 transforms data within one query graph but cannot call the separate notebook or impose cross-artefact ordering with retries and alerting, so it cannot orchestrate four distinct steps in sequence.

Why D is correct: A pipeline is Fabric's orchestration surface: it sequences a Copy, a Dataflow Gen2, and a notebook with on-success dependency links, adds per-activity retries, runs on a schedule trigger, and raises a failure alert, which is the dependency-aware control flow required.

See more DP-700 practice questions, answers explained.

Exam traps in Implement and Manage an Analytics Solution

Answers that look right on this material and are not. Each one is a distractor from a different question in the DP-700 bank for this domain.

  • A single Dataflow Gen2 that performs the copy, the curation, and the aggregation as a chain of Power Query steps so the whole process lives in one refreshable artefact.

    Why it is wrong: A Dataflow Gen2 transforms data within one query graph but cannot invoke a separate notebook or impose cross-activity ordering with retries and alerts, so it cannot orchestrate three distinct artefacts in sequence.

  • Replace each Copy activity with a Dataflow activity that runs a single Dataflow Gen2 holding all 80 sets of cleansing rules selected by a parameter at run time.

    Why it is wrong: A Dataflow Gen2 cannot run the PySpark rule logic the team has written, and packing 80 rule variants into one parameterised query is brittle; it also discards their existing code rather than reusing it.

  • Use a Dataflow Gen2 for the nested JSON flattening and scoring, and a Spark notebook for the small reference CSV trims and type change, then join the two outputs.

    Why it is wrong: This inverts the fit: Power Query is poorly suited to 6 GB of deep flattening and custom PySpark scoring, while using a Spark notebook for a trivial CSV trim is heavier than needed, so both engines are mismatched to their tasks.

More in this domain

Back to all Implement and Manage an Analytics Solution objectives, or the DP-700 cert hub.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.