DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ25

Plan and implement data platform resources

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance hosts 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?

Explanation

Azure Database Migration Service supports online migration to Azure SQL Managed Instance, continuously synchronizing source changes until cutover. This minimizes both application downtime and the potential for data loss during migration of a large SQL Server database.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!