Data pipelines are the gateway-compatible item to load a warehouse from on-prem SQL Server

DP-700 By islever Editorial Last updated

Ingest and transform batch data

Short answer

B A data pipeline connects to on-prem SQL Server via the data gateway and copies the data into Warehouse1 without transformation.

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?
  1. an Apache Spark job definition
  2. a data pipeline Correct Answer
  3. a Dataflow Gen1 dataflow
  4. an eventstream

Key Takeaways

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.

Common mistake: 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.

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.

Official Reference

https://learn.microsoft.com/en-us/fabric/fundamentals/decision-guide-pipeline-dataflow-spark

This link opens the official vendor documentation in a new tab.

Community Votes

B
100%

100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 4 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 4

  1. robertlavigne 👍 3 Answered B
    B. Notebooks and eventstreams can’t go through a gateway, . Gen1 dataflows are deprecated. Data pipelines work through a datagateway and are fast
  2. QAZdbarhate12345678 👍 3 Answered 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).
  3. Tuki93 👍 1 Answered B
    Dataflow Gen 1 is deprecated.
  4. MSka 👍 1 Answered B
    It’s B

Reader comments & corrections

No reader corrections 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.

A 500-million-row fact table exceeds the F32 Direct Lake guardrail, so increase the capacity to F64

S-grade

Shortcut caching supports only S3/GCS shortcuts and excludes files larger than 1 GB

S-grade

Updating warehouse tables requires at least the Contributor workspace role because Write is not shareable to a Viewer

S-grade

Run T-SQL in a KQL database only by prefixing the query with a -- comment line

S-grade

← Back to DP-700 Study Guide