DP-300 Question #46: Real Exam Question with Answer & Explanation

Question

Hotspot 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 an Azure SQL Database 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. Answer:

Options

• __typehotspot
• variantdropdown

Explanation

This question tests knowledge of configuring SQL Server backups for online migration to Azure SQL Managed Instance using Azure Database Migration Service (DMS). Specific backup settings are required for DMS to perform a continuous online migration with minimal downtime.

Approach. For an online migration using Azure Database Migration Service, DB1 must be backed up with the CHECKSUM option enabled - this ensures backup integrity and is a requirement for DMS to validate the backup files. The recovery model of DB1 must be set to FULL, because DMS requires full and transaction log backups to keep the target in sync with the source during the migration window. Additionally, backups should be placed in a network share (SMB share) that DMS can access, and the SQL Server service account must have read/write permissions to that share. Transaction log backups must be taken regularly during the migration to minimize data loss and allow for the cutover.

Concept tested. Azure Database Migration Service (DMS) online migration requirements for SQL Server to Azure SQL Managed Instance, specifically: recovery model must be FULL, backups must use CHECKSUM, and backups must be accessible via a network share or Azure Blob Storage for DMS to consume log backups continuously.

Reference. https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-managed-instance

No community discussion yet for this question.