Microsoft
DP-300 · Question #175
Hotspot Question You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1. You plan to perform an online migration of DB1 to an Azure SQL managed instance by using th
Sign in or unlock DP-300 to reveal the answer and full explanation for question #175. The question stem and answer options stay visible for context.
Submitted by carter_n· Mar 6, 2026Plan and implement data platform resources
Question
Hotspot Question You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1. You plan to perform an online migration of DB1 to an Azure SQL managed instance by using the Azure Database Migration Service. You need to create a backup of DB1 that is accessible to the Azure Database Migration Service. What should you run for the backup and where should you store the backup? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:
Exhibit
Answer Area
- Run:A full backup and a log backup appended to the same file by using the WITH CHECKSUM optionA full backup and a log backup to separate files by using the WITH CHECKSUM optionA full backup and a log backup to separate files by using the WITH FILE_SNAPSHOT option
- Store the backup in:A Recovery Services vaultAn Azure Blob storage accountAn SMB file share
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Azure Database Migration Service#SQL Managed Instance#Online migration#SQL backup