BenchMark Quizzes by MDFT Pro

Migrate To SQL Managed Instance With Minimal Downtime

You work for MDFT Pro, a well-known training agency with an on-premises datacenter containing a 2-TB Microsoft SQL Server 2019 database named LearningPlatform. Mark, the Minimal-Downtime Migration Architect, needs to migrate this large database to an Azure SQL managed instance. The LearningPlatform database serves thousands of students globally who access course materials, submit assignments, and take assessments 24/7. The database contains course content, student progress tracking, video streaming metadata, and certification records accumulated over many years. Mark requires a migration solution that minimizes downtime to avoid disrupting the continuous learning activities of students across different time zones, and minimizes administrative effort so the small database team doesn’t get overwhelmed with complex migration procedures.

What should you include in the recommendation?

Choose the correct answer from the options below.

Explanations for each answer:

Log Replay Service (LRS) is correct. Log Replay Service provides an automated way to migrate databases to SQL Managed Instance with minimal downtime by continuously replaying transaction logs.
log shipping is incorrect. While log shipping can be used for migration, it requires more manual configuration and administrative effort than Log Replay Service.
transactional replication is incorrect. Transactional replication can minimize downtime but requires more setup and administrative effort than Log Replay Service.
SQL Data Sync is incorrect. SQL Data Sync is designed for bi-directional synchronization between databases, not for one-time migrations to Managed Instance.

Learn more about Log Replay Service For SQL Managed Instance:

Log Replay Service

Practice Exam

Migrate To SQL Managed Instance With Minimal Downtime

Discuss this question on social media: