DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ35

VerifiedIngest and transform data

You have a Fabric workspace containing a warehouse named Warehouse1.

You have an on-premises Microsoft SQL Server database named Database1, accessed by using an on-premises data gateway.

You need to copy data from Database1 into Warehouse1.

Which item should you use?

Explanation

A Fabric data pipeline provides managed data movement through its Copy activity. It supports using an on-premises data gateway to read from an on-premises SQL Server source and loading the destination Fabric warehouse.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!