Which tool should you use to configure a pipeline to copy data?

You develop data engineering solutions for a company.

You must integrate the company’s on-premises Microsoft SQL Server data with Microsoft Azure SQL Database. Data must be transformed incrementally.

You need to implement the data integration solution.

Which tool should you use to configure a pipeline to copy data?
A . Use the Copy Data tool with Blob storage linked service as the source
B . Use Azure PowerShell with SQL Server linked service as a source
C . Use Azure Data Factory UI with Blob storage linked service as a source
D . Use the .NET Data Factory API with Blob storage linked service as the source

View Answer

Answer: C

Explanation:

The Integration Runtime is a customer managed data integration infrastructure used by Azure Data Factory to provide data integration capabilities across different network environments.

A linked service defines the information needed for Azure Data Factory to connect to a data resource.

We have three resources in this scenario for which linked services are needed:

✑ On-premises SQL Server

✑ Azure Blob Storage

✑ Azure SQL database

Note: Azure Data Factory is a fully managed cloud-based data integration service that orchestrates and automates the movement and transformation of data. The key concept in the ADF model is pipeline. A pipeline is a logical grouping of Activities, each of which defines the actions to perform on the data contained in Datasets. Linked services are used to define the information needed for Data Factory to connect to the data resources.

References: https://docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/move-sql-azure-adf