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. Data Pipeline - correct B. Apache Spark job definition Designed for data processing and transformation, not optimized for moving data via gateway. C. Streaming dataflow Used for real-time streaming data, not batch data movement from SQL Server. D. Notebook Can connect using JDBC/ODBC, but it doesn't support the gateway natively. Also requires more code and less suitable for production data movement.
Data Pipeline