DP-300 Certification Practice Question #44

Question

You have an on-premises datacenter that contains a 2-TB Microsoft SQL Server 2019 database named DB1.

You need to recommend a solution to migrate DB1 to an Azure SQL managed instance. The solution must minimize downtime and administrative effort.

What should you include in the recommendation?

Accepted Answer

Log Replay Service (LRS) is Microsoft's recommended solution for migrating large databases to Azure SQL Managed Instance with minimal downtime. It continuously replays transaction logs from on-premises to the cloud instance, enabling near-zero downtime migrations. It requires less administrative effort than transactional replication and is far more appropriate than the retiring SQL Data Sync. The Suggested Answer A and most weighted community signals strongly support LRS.

More DP-300 practice questions