You have a 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…

The correct answer is D. Backup and Restore. DMA does not support database migrations to Azure SQL Managed Instance. Recommendation is to use the Azure SQL migration extension for Azure Data Studio, which supports both online and offline database migrations to Azure SQL Managed Instance, but here we don´t have the option…

Submitted by fatima_kr· Mar 6, 2026Plan and implement data platform resources

Question

You have a 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?

Options

Alog shipping
BAlways On availability groups
CDatabase Migration Assistant
DBackup and Restore

How the community answered

(65 responses)

A
5% (3)
B
17% (11)
C
8% (5)
D
71% (46)

Explanation

DMA does not support database migrations to Azure SQL Managed Instance. Recommendation is to use the Azure SQL migration extension for Azure Data Studio, which supports both online and offline database migrations to Azure SQL Managed Instance, but here we don´t have the option "Azure SQL migration extension for Azure Data Studio". https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver16#capabilities Regarding log shipping to Managed Instance is not possible; it only supports the restore of full https://dba.stackexchange.com/questions/232332/is-it-possible-to-log-ship-from-on-premise-sql- server-to-azure-sql-managed-insta https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server- to-managed-instance-guide

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice