Question
You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1.
You need to perform an online migration of DB1 to Azure SQL Managed Instance by using Azure Database Migration Service.
How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Backup type: an online migration restores a full backup and then catches up with the log backups before cutover, so both are needed; a full backup alone cannot keep the target in sync, and log backups alone have no base to restore onto.
Backup option: WITH CHECKSUM helps prevent migrating a corrupt database and speeds up the restore. WITH NOINIT appends to an existing backup file, and appended backups in a single file are not supported because every backup must go on separate backup media. WITH UNLOAD only controls whether a tape is rewound and unloaded, so it does not help here.
