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…

The correct answer is A. Log Replay Service (LRS). The Log Replay service LRS is only used with Azure SQL Managed Instance. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service- migrate?view=azuresql-mi&tabs=sas-token

Submitted by renata2k· Mar 6, 2026Plan and implement data platform resources

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?

Options

ALog Replay Service (LRS)
Blog shipping
Ctransactional replication
DSQL Data Sync

How the community answered

(19 responses)

A
84% (16)
B
11% (2)
D
5% (1)

Explanation

The Log Replay service LRS is only used with Azure SQL Managed Instance. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service- migrate?view=azuresql-mi&tabs=sas-token

Topics

#Log Replay Service#SQL MI migration#minimal downtime#LRS

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice