DP-300 Certification Practice Question #23

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.
Hot Area:

Accepted Answer

When using Azure Database Migration Service (DMS) for an online migration of an on-premises database to Azure SQL Managed Instance, you must write the full database backup and subsequent transaction log backups to separate files (since appended files are not supported) using the `WITH CHECKSUM` option to ensure database integrity during restore. These backups must be stored in a local network location that the source SQL Server and DMS can access, which is specified as an SMB network share.

More DP-300 practice questions