DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ60

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

A Fabric data pipeline can use a Copy activity to copy data from an on-premises SQL Server connection through an on-premises data gateway to a Fabric Warehouse destination. Pipelines provide the data movement and orchestration required for this transfer.

Learn more

Community Discussion

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