DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ53

Plan and implement data platform resources

You have an on-premises datacenter that hosts 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?

Explanation

Log Replay Service (LRS) is the managed migration service for moving SQL Server databases to Azure SQL Managed Instance. Its continuous mode restores the initial backup and subsequent transaction-log backups while the source remains active, so downtime is limited to the final cutover and Azure performs the replay orchestration. Microsoft Learn: Overview of Log Replay Service

Learn more

Community Discussion

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