AZ-305 · Question #203
AZ-305 Question #203: Real Exam Question with Answer & Explanation
The correct answer is D: Azure Database Migration Service. 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
Question
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?
Options
- ASQL Server Migration Assistant (SSMA)
- BAzure Migrate
- CData Migration Assistant (DMA)
- DAzure Database Migration Service
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
Community Discussion
No community discussion yet for this question.