Implementing Data Engineering Solutions Using Microsoft Fabric — Question 6

You have a Fabric workspace that contains a warehouse named Warehouse1.
You have an on-premises Microsoft SQL Server database named Database1 that is accessed by using an on-premises data gateway.
You need to copy data from Database1 to Warehouse1.
Which item should you use?

Answer options

• A. a Dataflow Gen1 dataflow
• B. a data pipeline
• C. a KQL queryset
• D. a notebook

Correct answer: B

Explanation

The correct answer is B, a data pipeline, because it is specifically designed to facilitate the movement of data from one source to another, such as from an on-premises SQL Server to a warehouse. The other options, while useful for different purposes, do not serve the same function for direct data transfer.