Question
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?
- A. a Dataflow Gen1 dataflow
- B. a data pipeline Correct
- C. a KQL queryset
- D. a notebook
Explanation
A data pipeline Copy activity can connect to an on-premises SQL Server through an on-premises data gateway and load the data directly into a Fabric warehouse. A Dataflow Gen1 dataflow cannot write to a Fabric warehouse as a destination. A notebook cannot use an on-premises data gateway to reach Database1, and a KQL queryset only queries KQL databases; it does not copy data.
