DP-700 · Question #78
You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Workspace1 contains the following items: A Dataflow Gen2 dataflow that copies data from an on-premises…
The correct answer is D. data pipeline. To orchestrate the sequential loading of multiple Fabric items (Dataflow Gen2, notebook, data pipeline) and schedule them to run every 15 minutes, a data pipeline is the appropriate item type.
Question
- A Dataflow Gen2 dataflow that copies data from an on-premises Microsoft SQL Server database to Lakehouse1.
- A notebook that transforms files and loads the data to Lakehouse1
- A data pipeline that loads a CSV file to Lakehouse1 You need to develop an orchestration solution in Fabric that will load each item one after the other. The solution must be scheduled to run every 15 minutes. Which type of item should you use?
Exhibits
Options
- Anotebook
- Bworkspace
- CDataflow Gen2 dataflow
- Ddata pipeline
How the community answered
(26 responses)- A4% (1)
- B4% (1)
- D92% (24)
Why each option
To orchestrate the sequential loading of multiple Fabric items (Dataflow Gen2, notebook, data pipeline) and schedule them to run every 15 minutes, a data pipeline is the appropriate item type.
A notebook is used for data transformation and analysis using Spark but lacks native orchestration capabilities for other Fabric items and scheduling complex workflows.
A workspace is a container for Fabric items, not an orchestration tool itself.
A Dataflow Gen2 dataflow is used for data ingestion and transformation from various sources but cannot orchestrate other types of Fabric items or define sequential workflows across them.
Data pipelines in Microsoft Fabric are designed for orchestrating and automating data workflows, allowing you to define a sequence of activities including Dataflow Gen2, notebooks, and other data operations, and configure schedules for their execution. This enables the creation of complex ETL/ELT processes that run reliably at specified intervals.
Concept tested: Fabric data pipeline orchestration
Source: https://learn.microsoft.com/en-us/fabric/data-factory/create-first-data-pipeline
Topics
Community Discussion
No community discussion yet for this question.