Administering Relational Databases on Microsoft Azure — Question 41

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?

Answer options

Correct answer: A

Explanation

The Log Replay Service (LRS) is designed to efficiently migrate databases with minimal downtime by applying transaction logs during the migration process. In contrast, log shipping and transactional replication can involve more manual steps and potential downtime, while SQL Data Sync is not intended for large-scale database migrations.