A data pipeline copies on-premises SQL Server data through the gateway into a warehouse
Ingest and transform batch data
AnswerCorrect answer: B - A data pipeline's Copy data activity reaches on-prem SQL Server through the gateway and loads Warehouse1 efficiently 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
Data pipelines are the gateway-compatible, most efficient copy engine for lifting on-prem SQL Server data into a warehouse; notebooks and eventstreams cannot run through the data gateway and Gen1 dataflows are deprecated.
A data pipeline with a Copy data activity connects to on-premises SQL Server through the on-premises data gateway and copies Database1 into Warehouse1 efficiently with no transformation required.
Choosing a notebook because it can query SQL Server; notebooks cannot connect through the on-premises data gateway, and a Dataflow Gen1 dataflow is deprecated.
Community Discussion (6 comments)
robertlavigne👍 8Selected: B
B. Notebooks can’t go through a gateway, KQL isn’t appropriate for a sql db. Gen1 dataflows are deprecated. Data pipelines work through a datagateway and are fast
CMDev👍 1Selected: B
It says, you need to copy data, dont specify if we need to do some transformations. In this case, a data pipeline with an activity "copy data" is enough and the best choice in terms of efficency and minimal effort. Check this link: https://learn.microsoft.com/en-us/fabric/fundamentals/decision-guide-pipeline-dataflow-spark
arunmewada👍 1Selected: B
I attempted to use a data pipeline to load data directly from on-premises to the warehouse, but since the warehouse does not support external sources, I first loaded the data into a Lakehouse and then moved it to the warehouse.
mmanrik👍 2Selected: B
A data pipeline, since it has the "Copy data" activity, the most efficient way to copy data into fabric when there are no transformations to be done (if there are a Dataflow Gen 2 might be better, depends on the amount of data to be copied).
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👍 2Selected: 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 connects to SQL Server through the on-premises data gateway and lands the data in Fabric, making it the supported and most efficient item for copying Database1 into Warehouse1 when no transformation is needed. The pipeline decision guide recommends pipelines precisely for this no-transformation, throughput-oriented copy scenario.
Why the Other Options Are Wrong
Option A (a Dataflow Gen1 dataflow) is deprecated in favor of Dataflow Gen2. Option C (a KQL queryset) queries KQL databases and cannot ingest from on-prem SQL Server through the gateway. Option D (a notebook) cannot reach the on-prem source through the data gateway.
Community Comment Notes
The community is unanimous (B 100). robertlavigne (8 likes) notes notebooks cannot go through a gateway, KQL is inappropriate for a SQL database, and Gen1 dataflows are deprecated. mmanrik (2 likes) points to the Copy data activity as the most efficient no-transformation option, and CMDev links the pipeline/dataflow decision guide.