DP-300 Certification Practice Question #29

Question

You have an on-premises Microsoft SQL Server named SQL1 that hosts five databases.
You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss.
What should you use?

Accepted Answer

The question asks for what to use among the four listed choices. DMA (D) explicitly does not support migrations to Azure SQL Managed Instance per MS docs. Log shipping (C) is not natively supported for restoring to SQL MI. Always On AG (A) for migration is a link-feature scenario not covered by traditional on-premises AG. By elimination, Backup and Restore (B) is the only viable option from those listed, which is why it garnered an overwhelming 21 community votes. The "minimize downtime" caveat is partially addressed by using full + differential + log backups in sequence.

More DP-300 practice questions