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

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

Latest AZ-305 Dumps Valid Version with 78 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments