What should you use to minimize downtime and data loss during the migration?

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 an Azure SQL Database managed instance.

What should you use to minimize downtime and data loss during the migration?
A . distributed availability groups
B . database mirroring
C . log shipping
D . Database Migration Assistant

View Answer

Answer: A

Explanation:

The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by

detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server. NOTE: SQL Managed Instance supports the following database migration options (currently these are the only supported migration methods):

✑ Azure Database Migration Service – migration with near-zero downtime.

✑ Native RESTORE DATABASE FROM URL – uses native backups from SQL Server and requires some downtime.

Reference: https://docs.microsoft.com/en-us/sql/dma/dma-overview