Exam AZ-304 topic 3 question 28 discussion

Box 1: Azure SQL database - Box 2: Azure-SQL Server Integration Service Integration Runtime and self-hosted integration runtime

Why Self hosted IR? This article describes how to run SQL Server Integration Services (SSIS) packages on an Azure-SSIS Integration Runtime (Azure-SSIS IR) in Azure Data Factory with a self-hosted integration runtime (self-hosted IR) configured as a proxy. With this feature, you can access data on-premises without having to join your Azure-SSIS IR to a virtual network. The feature is useful when your corporate network has a configuration too complex or a policy too restrictive for you to inject your Azure-SSIS IR into it. https://docs.microsoft.com/en-us/azure/data-factory/self-hosted-integration-runtime-proxy-ssis As Azure cloud does not connectivity to on Premise network you would need to implement self Hosted-IR as well

Correct answer given

Provision. Before you can deploy and run SSIS packages in Azure, you have to provision the SSIS Catalog (SSISDB) and the Azure-SSIS Integration Runtime. You don't need a self-hosted integration runtime also because the catalog is now in an Azure SQL SSIS DB.

https://docs.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-lift-shift-ssis-packages-overview?view=sql-server-ver15 You can now move your SQL Server Integration Services (SSIS) projects, packages, and workloads to the Azure cloud. Deploy, run, and manage SSIS projects and packages in the SSIS Catalog (SSISDB) on Azure SQL Database or SQL Managed Instance with familiar tools such as SQL Server Management Studio (SSMS). https://docs.microsoft.com/en-us/azure/data-factory/self-hosted-integration-runtime-proxy-ssis With this feature, you can access data and run tasks on premises without having to join your Azure-SSIS IR to a virtual network Answer is correct

Correct

To run SSIS packages, you need "Azure-SQL Server Integration services Integration runtime" https://www.youtube.com/watch?v=weiHOeje-QA min 3:07. To connect without VPN or Express Route, you need to install a self-hosted integration runtime that acts as a proxy (as seen on video). Then the second Box is: "Azure-SQL Server Integration services Integration runtime and self-hosted integration". For the first one, I guess Azure SQL Database.

Select the Set up Self-Hosted Integration Runtime as a proxy for your Azure-SSIS Integration Runtime check box to choose whether you want to configure a self-hosted IR as proxy for your Azure-SSIS IR. Since we migrated completely to azure this is not needed. Box 1 is azure sql database and Box 2 is azure SSIS IR only. (https://docs.microsoft.com/en-us/azure/data-factory/self-hosted-integration-runtime-proxy-ssis)

Correct answer

The installation of a self-hosted integration runtime needs an on-premises machine or a virtual machine inside a private network. I would select 2 for Box 2.

is this even in the syllabus... id ont see any mention of this in MS learn

the second answer would be C only if you have a stable Site to Site connectivity or ER. without this, an SSIS IR only is the correct answer. I know the question is so misleading :)

In my opinion the answer is correct, as per your reference @uzairahm007, "This article describes how to run SQL Server Integration Services (SSIS) packages on an Azure-SSIS Integration Runtime (Azure-SSIS IR) in Azure Data Factory with a self-hosted integration runtime (self-hosted IR) configured as a proxy. With this feature, you can access data on-premises without having to join your Azure-SSIS IR to a virtual network. The feature is useful when your corporate network has a configuration too complex or a policy too restrictive for you to inject your Azure-SSIS IR into it." So both self hosted and Azure SSIS IR are needed for this feature to work.

second one should be IR only. as self-hosting is running on on-prem network. but it also mentioned 'The on-premises network does not have hybrid connectivity to Azure by using Site-to-Site VPN or ExpressRoute'

so whats the answer then ?