Data Engineering on Microsoft Azure — Question 93

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?

Answer options

• A. self-hosted integration runtime
• B. Azure integration runtime
• C. Azure-SQL Server Integration Services (SSIS)

Correct answer: A

Explanation

The correct answer is A, the self-hosted integration runtime, because it enables data movement from on-premises environments to Azure. Option B, the Azure integration runtime, is designed for cloud-based data sources and cannot connect to on-premises databases. Option C, Azure-SQL Server Integration Services (SSIS), is a different service used for ETL processes and does not apply directly to this scenario.