BenchMark Quizzes by MDFT Pro

Migrate Five Databases To Azure SQL Managed Instance

You work for MDFT Pro, a well-known training agency with an on-premises Microsoft SQL Server named TrainingServer that hosts five critical databases. Mark, the Infrastructure Migration Manager, needs to migrate all five databases to an Azure SQL managed instance to modernize the infrastructure and reduce maintenance overhead. The five databases include StudentRecords, CourseCatalog, AssessmentResults, TrainerSchedules, and CertificationTracking. These databases contain vital operational data that must remain consistent and available, and the migration must minimize downtime to avoid disrupting the ongoing training sessions and student assessments. Mark also wants to ensure that no data is lost during the migration process. He has asked you to recommend the most appropriate migration method.

What should you use?

Choose the correct answer from the options below.

Explanations for each answer:

Always On availability groups is incorrect. While Always On can minimize downtime, it requires more configuration and doesn't prevent data loss as effectively as backup and restore for managed instance migrations.
Backup and Restore is correct. Backup and restore to Azure Blob Storage with continuous log backups provides minimal downtime and prevents data loss when migrating to SQL Managed Instance.
log shipping is incorrect. Log shipping is not the optimal solution for migrating to SQL Managed Instance as backup/restore with continuous log backups is more efficient.
Database Migration Assistant is incorrect. Database Migration Assistant is used for assessment and schema migration, but doesn't minimize downtime and prevent data loss as effectively as backup/restore for managed instances.

Learn more about Migrating To Azure SQL Managed Instance:

Migrating To SQL Managed Instance

Practice Exam

Migrate Five Databases To Azure SQL Managed Instance

Discuss this question on social media: