Implementing Data Engineering Solutions Using Microsoft Fabric — Question 36

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 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?

Answer options

Correct answer: D

Explanation

The correct answer is D, as a data pipeline is specifically designed to automate the loading of data and can be scheduled to run at specified intervals. The other options, such as notebooks and Dataflow Gen2 dataflows, are used for data transformation and processing but do not inherently provide orchestration capabilities for sequential execution of multiple tasks.