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…

The correct answer is D. Azure Database Migration Service. When you migrate databases to Azure by using Azure Database Migration Service, you can do an offline or an online migration. With an offline migration, application downtime starts when the migration starts. With an online migration, downtime is limited to the time to cut over…

Submitted by helene.fr· Mar 6, 2026Plan and implement data platform resources

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?

Options

Adistributed availability groups
Bdatabase mirroring
Clog shipping
DAzure Database Migration Service

How the community answered

(43 responses)

A
9% (4)
B
2% (1)
C
5% (2)
D
84% (36)

Explanation

When you migrate databases to Azure by using Azure Database Migration Service, you can do an offline or an online migration. With an offline migration, application downtime starts when the migration starts. With an online migration, downtime is limited to the time to cut over at the end of migration. We suggest that you test an offline migration to determine whether the downtime is acceptable; if not, do an online migration. https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-managed-instance

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice