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?
To copy data from an on-premises Linux server to an Azure Data Lake Storage account using Azure Data Factory, you should use a self-hosted integration runtime. This allows data movement between on-premises databases and Azure services. While the self-hosted integration runtime must run on a Windows machine, it can connect to databases on Linux servers through the use of appropriate database connectors and drivers that support remote connections to the Linux-based database.
This was a hard question, but indeed apparently Self-hosted integration runtime only supports windows, and Azure is for cloud platforms, so the answer is the SSIS, though it's a bit overkill because SSIS is meant for transformations
Correct
ChatGPT confirmed self-hosted integration runtime
the self-hosted integration runtime cannot be installed directly on a Linux server, you can set it up on a Windows machine within your network to facilitate data movement between an on-premises Linux database and Azure services.
A. Self Hosted integration run times will work but SHIR need to be installed on a windows machine in same network of Linux with supported DB driver. Its not easy but still very much possible.
After thinking, I think it will be better to use SSIS.
Although the self-hosted IR runs on Windows, it can connect to databases hosted on Linux servers. This is possible because the self-hosted IR uses database connectors and drivers that support remote connections to databases on different operating systems.
SSIS is correct, albeit a bit overkill, because self hosted can only run on windows, this makes it the best option
Azure-SQL Server Integration Services (SSIS) is currently supported for connecting to on-premises Linux servers. The other two options aren't.
C As self-hosted integration runtime is only supported in Windows OS, Azure IR only supports withing Azure cloud platforms