Data pipelines are the gateway-compatible item to load a warehouse from on-prem SQL Server
Ingest and transform batch data
AnswerCorrect answer: B - A data pipeline connects to on-prem SQL Server via the data gateway and copies the data into Warehouse1 without transformation.
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?
100% of anonymous learners picked answer B.
Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
Among Fabric items, only data pipelines support on-premises data gateway sources for a direct, high-throughput copy into a warehouse; Spark job definitions and eventstreams cannot use the gateway and Gen1 dataflows are deprecated.
To copy data from the on-premises SQL Server database Database1 into Warehouse1, use a data pipeline: its Copy data activity works through the on-premises data gateway and moves the data efficiently without transformation.
Choosing an Apache Spark job definition or eventstream for the on-prem copy; neither can consume data through the on-premises data gateway, leaving the data pipeline as the only viable item.
Community Discussion (4 comments)
MSka👍 1Selected: B
It’s B
robertlavigne👍 3Selected: B
B. Notebooks and eventstreams can’t go through a gateway, . Gen1 dataflows are deprecated. Data pipelines work through a datagateway and are fast
QAZdbarhate12345678👍 3Selected: B
In this case, a data pipeline can be used to transfer data from Database1 (the SQL Server database) to Warehouse1 (in the Fabric workspace).
Tuki93👍 1Selected: B
Dataflow Gen 1 is deprecated.
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Log in to comment, report an error, or add a note about this question.
Expert Analysis
Why the Answer Is Correct
A data pipeline's Copy data activity supports SQL Server as a source through the on-premises data gateway and writes into Fabric efficiently, which fits the no-transformation copy into Warehouse1. The pipeline decision guide positions pipelines as the right item for scalable, transformation-free data movement.
Why the Other Options Are Wrong
Option A (an Apache Spark job definition) cannot ingest the on-prem source through the data gateway. Option C (a Dataflow Gen1 dataflow) is deprecated in favor of Dataflow Gen2. Option D (an eventstream) ingests real-time streaming sources and is not a gateway-based SQL ingestion tool.
Community Comment Notes
The community is unanimous (B 100). robertlavigne (3 likes) notes notebooks and eventstreams cannot go through a gateway and Gen1 dataflows are deprecated, and QAZdbarhate12345678 (3 likes) confirms a data pipeline transfers data from the SQL Server database into the Fabric warehouse.