You have an on-premises Linux server that contains a database named DB1. You have an Azure subscription that contains an Azure data factory named ADF1 and an Azure Data Lake Storage account named ADLS1. You need to create a pipeline in ADF1 that will copy data from DB1 to ADLS1. Which type of integration runtime should you use to read the data from DB1?

Question

Accepted Answer

C. Azure-SQL Server Integration Services (SSIS) The Azure-SSIS integration runtime hosts SSIS packages natively in Azure, providing the execution environment for SSIS-based pipelines that must connect to and extract data from on-premises databases. When the pipeline design leverages SSIS packages to copy data from DB1, only the Azure-SSIS IR supplies the necessary SSIS runtime capabilities within ADF1.

Answer

A. self-hosted integration runtime A self-hosted integration runtime enables direct ADF Copy Activity connectivity to on-premises data sources but does not provide the SSIS execution environment needed when the pipeline relies on SSIS packages.

Answer

B. Azure integration runtime The Azure integration runtime runs entirely within Azure's managed cloud infrastructure and cannot reach an on-premises server without public exposure, making it unsuitable for reading from an on-premises DB1.

You have an on-premises Linux server that contains a database named DB1. You have an Azure subscription that contains an Azure data factory named ADF1 and an Azure Data Lake Storage account named…

Question

Options

How the community answered

Why each option

Topics

Community Discussion