DP-300 Certification Practice Question #5

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 an Azure SQL Database managed instance.
What should you use to minimize downtime and data loss during the migration?

Accepted Answer

To migrate a 4-TB on-premises database to Azure SQL Database Managed Instance with minimal downtime and data loss, Azure Database Migration Service (DMS) is the recommended option. When running DMS in online mode, it continuously replicates transactions from the source database to the target, allowing the databases to remain synchronized. Downtime is then minimized to the brief period required to perform the final cutover.

More DP-300 practice questions