BenchMark Quizzes by MDFT Pro

Configure Backup For Azure Database Migration Service

You work for MDFT Pro, a well-known training agency with an on-premises Microsoft SQL Server 2019 instance that hosts a critical database named StudentRecords. Mark, the Migration Architect, has planned an online migration of StudentRecords to an Azure SQL managed instance using the Azure Database Migration Service to minimize downtime during the transition. The StudentRecords database contains enrollment information, course completions, and assessment scores for thousands of students, and it must remain available during the migration process. Mark has asked you to prepare the database backups in the proper format and location so that the Azure Database Migration Service can access them during the migration.

What should you run for the backup and where should you store the backup?

Choose all correct answers from the options below.

Explanations for each answer:

Run a full backup and a log backup appended to the same file using the WITH CHECKSUM option is incorrect. Azure Database Migration Service requires separate files for full and log backups, not backups appended to the same file.
Run a full backup and a log backup to separate files using the WITH CHECKSUM option is correct. Azure Database Migration Service requires full and log backups in separate files with the CHECKSUM option to validate backup integrity during migration.
Run a full backup and a log backup to separate files using the WITH FILE_SNAPSHOT option is incorrect. FILE_SNAPSHOT is used for Azure storage but isn't the required option for Azure Database Migration Service. CHECKSUM is needed.
Store the backup in a recovery services vault is incorrect. Azure Database Migration Service doesn't access backups from Recovery Services Vault. It requires backups in Azure Blob Storage.
Store the backup in an Azure Blob Storage account is correct. Azure Database Migration Service reads backups from Azure Blob Storage, so the backup files must be stored there.
Store the backup in an Azure Virtual Machine disk is incorrect. Azure Database Migration Service cannot access backups stored on VM disks. Backups must be in Azure Blob Storage.

Learn more about Migrating To Azure SQL Managed Instance Online:

Migrating To SQL Managed Instance

Practice Exam

Configure Backup For Azure Database Migration Service

Discuss this question on social media: