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. an Apache Spark job definition
- B. a data pipeline Correct
- C. a Dataflow Gen1 dataflow
- D. an eventstream
Explanation
A data pipeline Copy activity supports an on-premises data gateway connection to SQL Server and can write directly to a Fabric warehouse. An Apache Spark job definition cannot use the on-premises data gateway. A Dataflow Gen1 dataflow cannot load into a Fabric warehouse, and an eventstream ingests streaming events rather than copying tables from a SQL Server database.
