Exam AZ-301 topic 5 question 11 discussion

is it not B, Azure Data Factory?

https://docs.microsoft.com/bs-cyrl-ba/azure/sql-database/sql-database-managed-instance-migrate Quote from that page "Azure SQL Database and SQL Server databases in an Azure Virtual Machine. DMS is the recommended method of migration for your enterprise workloads. If you use SQL Server Integration Services (SSIS) on your SQL Server on premises, DMS does not yet support migrating SSIS catalog (SSISDB) that stores SSIS packages, but you can provision Azure-SSIS Integration Runtime (IR) in Azure Data Factory (ADF) that will create a new SSISDB in a managed instance and then you can redeploy your packages to it, see Create Azure-SSIS IR in ADF. To learn more about this scenario and configuration steps for DMS, see Migrate your on-premises database to managed instance using DMS." Therefor answer is B -> Data Factory

ssis-adf

https://docs.microsoft.com/en-us/azure/dms/how-to-migrate-ssis-packages

B ( Azure Data Factory) is correct Azure Data Factory hosts the runtime engine for SSIS packages on Azure. The runtime engine is called the Azure-SSIS Integration Runtime (Azure-SSIS IR) https://docs.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-lift-shift-ssis-packages-overview?view=sql-server-ver15

B. Azure Data Factory

Azure Data Factory correct answer.

Given answer is correct. Pay attention to "SQL Database instances as their destinations." "The solution must ensure that the packages can target the SQL Database instances as their destinations."

Correct answer: B. Data Factory To lift & shift your on-premises SQL Server Integration Services (SSIS) workloads to the cloud, you can provision Azure-SSIS Integration Runtime (IR) in Azure Data Factory (ADF) https://docs.microsoft.com/en-us/azure/data-factory/azure-ssis-integration-runtime-package-store#:~:text=They%20provide%20a%20package%20management,the%20legacy%20SSIS%20package%20store.

If asked to recommend a solution (currently) - Data Factory If asked to assess - Data Migration Assistant

Azure-SSIS Integration Runtime, a component of Azure Data Factory https://docs.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-lift-shift-ssis-packages-overview?view=sql-server-ver15

B) See https://docs.microsoft.com/en-us/azure/data-factory/scenario-ssis-migration-overview - See section "Azure SQL Database as database workload destination"

"recommend a solution to host the SSIS packages in Azure." I would go with B. Data Factory since both SSIS and Data Factory are ETL solutions. https://docs.microsoft.com/en-us/sql/integration-services/lift-shift/ssis-azure-lift-shift-ssis-packages-overview?view=sql-server-ver15

C is the one. REF: https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15 Assess on-premises SQL Server Integration Services (SSIS) package(s) migrating to Azure SQL Database or Azure SQL Managed Instance. The assessment helps to discover issues that can affect the migration.

Architecture of SSIS on Azure The following table highlights the differences between SSIS on premises and SSIS on Azure. The most significant difference is the separation of storage from runtime. Azure Data Factory hosts the runtime engine for SSIS packages on Azure. The runtime engine is called the Azure-SSIS Integration Runtime (Azure-SSIS IR). For more info, see Azure-SSIS Integration Runtime. B

https://docs.microsoft.com/en-us/azure/data-factory/scenario-ssis-migration-overview B?

Its surely Data Factory