BenchMark Quizzes by MDFT Pro

Configure Backups For Online Migration To SQL Managed Instance

You work for MDFT Pro, a well-known training agency with an on-premises Microsoft SQL Server 2016 instance hosting a database named CourseManagement. Mark, the Online Migration Specialist, has an Azure subscription containing an Azure SQL managed instance named TrainingCloud. He plans to perform an online migration of CourseManagement to TrainingCloud using the Azure Database Migration Service to minimize downtime during the transition. The CourseManagement database is actively used 24/7 by students and trainers for course registration, progress tracking, and certification management. Mark needs to prepare the appropriate backup strategy that will support the online migration process while minimizing the total number of backup files created to simplify management and reduce storage overhead.

Which type of backups should you create, and how should you store the backups?

Choose all correct answers from the options below.

Explanations for each answer:

You should create a full backup only is incorrect. For online migration, you need both full and transaction log backups to support continuous synchronization until cutover.
You should create a full and a differential backup is incorrect. For online migration to Managed Instance, you need full and transaction log backups, not differential backups.
You should create a full and a transaction log backup is correct. Online migration requires a full backup followed by continuous transaction log backups to keep the target database synchronized until cutover.
You should create a transaction log backup only is incorrect. You cannot restore transaction log backups without first restoring a full backup.
You should append all backups to a single file is incorrect. Appending multiple backups to a single file would not minimize the number of backup files and is not the recommended approach.
You should write each backup to a separate file is correct. Writing each backup to a separate file allows for parallel processing and minimizes the total number of files while maintaining efficiency.

Learn more about Online Migration To SQL Managed Instance:

Online Migration To Managed Instance

Practice Exam

Configure Backups For Online Migration To SQL Managed Instance

Discuss this question on social media: