DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ54

VerifiedIngest and transform data

You have a Fabric workspace that includes 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 to Warehouse1.

Which item should you use?

Explanation

Fabric Data Factory pipelines support Copy activity for copying data from an on-premises SQL Server source through an on-premises data gateway to a destination such as a Fabric warehouse. Pipelines are the low-code ingestion workflow designed to copy data from a source to a destination.

Learn more

Community Discussion

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