Designing Azure Infrastructure Solutions — Question 64

You have an on-premises Microsoft SQL server named SQL1 that hosts 50 databases.

You plan to migrate SQL1 to Azure SQL Managed Instance.

You need to perform an offline migration of SQL1. The solution must minimize administrative effort.

What should you include in the solution?

Answer options

• A. Azure Migrate
• B. Azure Database Migration Service
• C. SQL Server Migration Assistant (SSMA)
• D. Data Migration Assistant (DMA)

Correct answer: B

Explanation

The correct answer is B, Azure Database Migration Service, which is specifically designed to facilitate database migrations with minimal administrative overhead. Options A, C, and D do not provide the same level of automation and efficiency for an offline migration as Azure Database Migration Service does.