Question
You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.
You plan to migrate DB1 to Azure SQL Managed Instance.
What should you use to minimize downtime and data loss during the migration?
- A. distributed availability groups
- B. database mirroring
- C. Always On Availability Group
- D. Azure Database Migration Service Correct
Explanation
Azure Database Migration Service is a recommended migration option for SQL Managed Instance and offers migration with near-zero downtime: backups are restored continuously and the cutover happens only after all backups are restored. Database mirroring and a standard Always On Availability Group are not listed migration methods for moving a database to a managed instance. Distributed availability groups are also not one of the documented migration options as such.
