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…

The correct answer is B. A data pipeline. A data pipeline is the correct tool for copying data from an on-premises SQL Server database to a Fabric Warehouse. Data pipelines in Microsoft Fabric support on-premises data gateways, which are required to connect to on-premises sources like Database1. They provide a…

Design and implement data ingestion and 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?

Options

AA dataflow Gen1 dataflow
BA data pipeline
CA KQL queryset
DA notebook

How the community answered

(41 responses)

A
12% (5)
B
78% (32)
C
7% (3)
D
2% (1)

Explanation

A data pipeline is the correct tool for copying data from an on-premises SQL Server database to a Fabric Warehouse. Data pipelines in Microsoft Fabric support on-premises data gateways, which are required to connect to on-premises sources like Database1. They provide a dedicated 'Copy Data' activity that moves data directly into a Warehouse destination. The other options are incorrect because: (A) Dataflow Gen1 is primarily designed for Power BI datasets and lacks direct Warehouse write support; (C) KQL querysets are for querying KQL/Eventhouse databases, not for data movement; (D) Notebooks can technically move data but require custom code and are not the intended or recommended solution for straightforward data copy scenarios from on-premises sources.

Topics

#Data integration#Microsoft Fabric#Data pipelines#On-premises data gateway

Community Discussion

No community discussion yet for this question.

Full DP-700 Practice