To connect to and transform data to be loaded into a Fabric lakehouse using Dataflows Gen2, which sequence completes the task?

Prepare for the DP-700 Microsoft Fabric Data Engineer Exam with flashcards and multiple choice questions. Study with hints and explanations, and ensure success on your certification exam!

Multiple Choice

To connect to and transform data to be loaded into a Fabric lakehouse using Dataflows Gen2, which sequence completes the task?

Explanation:
The main idea is using Dataflows Gen2 to perform the ETL step inside Fabric before loading into the lakehouse. Start by connecting to your data source via a Data Factory workload, then create a Dataflow Gen2 to transform the data, and finally set the lakehouse as the destination where the transformed data is written. This pattern keeps transformation logic centralized in the dataflow and prepares data in the lakehouse for analytics. Other sequences don’t fit because they either focus on streaming or real-time pipelines, or they load data elsewhere (like directly transforming inside the lakehouse after a copy, or sending data to Power BI). Dataflows Gen2 with the lakehouse destination is the appropriate path for batch ETL into Fabric lakehouse.

The main idea is using Dataflows Gen2 to perform the ETL step inside Fabric before loading into the lakehouse. Start by connecting to your data source via a Data Factory workload, then create a Dataflow Gen2 to transform the data, and finally set the lakehouse as the destination where the transformed data is written. This pattern keeps transformation logic centralized in the dataflow and prepares data in the lakehouse for analytics.

Other sequences don’t fit because they either focus on streaming or real-time pipelines, or they load data elsewhere (like directly transforming inside the lakehouse after a copy, or sending data to Power BI). Dataflows Gen2 with the lakehouse destination is the appropriate path for batch ETL into Fabric lakehouse.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy