What should you include in the solution?

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

You plan to migrate SQL 1 to Azure SQL Managed Instance.

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

What should you include in the solution?
A . SQL Server Migration Assistant (SSMA)
B . Azure Migrate
C . Data Migration Assistant (DMA)
D . Azure Database Migration Service

View Answer

Answer: D

Explanation:

This Azure service supports migration in the offline mode for applications that can afford downtime during the migration process. Unlike the continuous migration in online mode, offline mode migration runs a one-time restore of a full database backup from the source to the target

https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-overview?view=azuresql#compare-migration-options