Exam AZ-305 topic 4 question 104 discussion

The best solution for this scenario is: B. Azure Database Migration Service Azure Database Migration Service is a tool that helps you simplify, guide, and automate your database migration to Azure. Specifically for SQL Server to Azure SQL Managed Instance migrations, it provides an option for offline (one-time) migrations which is suitable for your scenario. The Data Migration Assistant (DMA) tool can be used beforehand to assess your SQL Server databases for any feature parity and compatibility issues that could impact the database functionality in Azure SQL Managed Instance. Azure Migrate is a service that helps you assess and migrate applications, infrastructure, and data, but it doesn't specifically cater to SQL Server migrations. SQL Server Migration Assistant (SSMA) is more suited for migrations to Azure SQL Database and does not support Azure SQL Managed Instance.

Azure Database Migration Service (classic) - SQL scenarios are on a deprecation path. Since August 1, 2023, you're no longer able to create new Database Migration Service (classic) resources for SQL Server scenarios from Azure portal. The service will be retired on March 15, 2026 for all customers. You can migrate to Azure SQL Database using the latest version of Azure Database Migration Service, which is available as an extension in Azure Data Studio, or by using Azure PowerShell and Azure CLI. For more information, see Retirement notice: Database Migration Service (classic).

For an offline migration of SQL1 (50 databases) to Azure SQL Managed Instance while minimizing administrative effort, the best approach is: ✅ Recommended: Azure Database Migration Service (DMS) for Offline Migration Why Azure DMS? Automates Migration Workflow – Simplifies database migration, reducing manual effort. Supports SQL Server 2008+ – Ensures seamless migration from older SQL Server versions. Preserves Schema & Data – Ensures full database structure remains intact. Offline Migration Mode – Minimizes complexity by performing a single cutover when ready.

DMA is needed if you want to assess before migration with DMS. Alternatively, if you use the Azure SQL Migration extension in Azure Data Studio, you can run assessments and migrations in a single place. The Data Migration Assistant provides seamless assessments of SQL Server on-premises and upgrades to later versions of SQL Server or migrations to SQL Server on Azure VMs or Azure SQL Database. It also help you helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database.

DMA is needed if you want to assess before migration with DMS. Alternatively, if you use the Azure SQL Migration extension in Azure Data Studio, you can run assessments and migrations in a single place. The Data Migration Assistant provides seamless assessments of SQL Server on-premises and upgrades to later versions of SQL Server or migrations to SQL Server on Azure VMs or Azure SQL Database. It also help you helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database.

Given answer B is correct, Considering MS have so many tools and features it is more confusing than ever, i found great link that compare the 3 answers BCD hope it helps https://techcommunity.microsoft.com/t5/microsoft-data-migration-blog/differentiating-microsoft-s-database-migration-tools-and/ba-p/368529

Use the Database Migration Service in the following scenarios: Migrate both databases to Azure SQL, especially at scale, and for extensive (in terms of number and size of databases) migrations. Migrate databases to Azure Database. https://learn.microsoft.com/en-us/sql/sql-server/migrate/dma-azure-migrate-compare-migration-tools?view=sql-server-ver16#quick-compariso

https://learn.microsoft.com/en-us/sql/sql-server/migrate/dma-azure-migrate-compare-migration-tools?view=sql-server-ver16#quick-comparison