Implementing Data Engineering Solutions Using Microsoft Fabric — Question 7

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. an Apache Spark job definition
• B. a data pipeline
• C. a Dataflow Gen1 dataflow
• D. an eventstream

Correct answer: B

Explanation

The correct choice is B, a data pipeline, as it is specifically designed for transferring and transforming data between data sources and destinations. The other options, such as an Apache Spark job definition, a Dataflow Gen1 dataflow, and an eventstream, do not serve the primary purpose of directly copying data from a database to a warehouse in this context.