Microsoft Azure Architect Design (legacy) — Question 62

You have 100 Microsoft SQL Server Integration Services (SSIS) packages that are configured to use 10 on-premises SQL Server databases as their destinations.
You plan to migrate the 10 on-premises databases to Azure SQL Database.
You need to recommend a solution to host the SSIS packages in Azure. The solution must ensure that the packages can target the SQL Database instances as their destinations.
What should you include in the recommendation?

Answer options

Correct answer: C

Explanation

The correct answer is C, Data Migration Assistant, because it assists in assessing and migrating databases to Azure SQL Database. The other options are not suitable for hosting SSIS packages or targeting SQL Database instances directly. SQL Server Migration Assistant is primarily for migrating databases, Azure Data Factory is for orchestrating data workflows, and Azure Data Catalog is for metadata management.