Exam DP-300 topic 1 question 39 discussion

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 backups. https://dba.stackexchange.com/questions/232332/is-it-possible-to-log-ship-from-on-premise-sql-server-to-azure-sql-managed-insta So the only option that we can use is Backup and Restore

as explained here https://learn.microsoft.com/en-us/data-migration/sql-server/managed-instance/guide

My answer: B. Backup and Restore wrong answers: A. SQL MI can't be part of AG C. SQL MI doesn't support traditional Log Shipping D. DMA can help migrate your database schema and data to the target environment, but simple backup and restore will be faster option IMHO (less downtime)

Note the use of the word minimum down time: Here is an excerpt from the Microsoft website: https://learn.microsoft.com/en-us/data-migration/sql-server/managed-instance/overview. Managed Instance link : This feature enables online migration to SQL Managed Instance by using Always On availability technology to replicate changes nearly real time. It's a migration option for customers who require the database on SQL Managed Instance to be accessible in R/O mode while the migration is in progress, who need to keep the migration running for prolonged periods of time (such as weeks or months at a time), who require true online replication to the Business Critical service tier, and for customers who require the most performant minimum downtime migration.

Must be A, according to the 'Hybrid data synchronization' paragraph and the 'Migration by platform' table: https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-retirement-migration?view=azuresql

A - B and D do not minimise downtime - only the always on Av Groups can meet the requirements

I'm kind of agree that the correct answer is D. Here is my guess as to why. In the question it saying "You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss." I think who ever asking this, actually looking for more solution to minimize downtime and prevent data loss. By using DMA you have an option to evaluate if migration will be successful. modern data platform by detecting compatibility issues. I can't simply take DB and migrate it, Right? First evaluation then actual Migration. I'm personally choosing D.

Hi everyone, why can't use the Always on availability group?

https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver16

Changing my mind on this - Believe answer is B after reviewing. Migration Service is different from Migration Assistant. Migration Assistant only assesses databases for migration

I believe answer is correct - D. Database Migration Service is used to restore backups for the migration. See Question 33 for details (2nd line in question)

DMA does not support database migrations to Azure SQL Managed Instance. Use the Azure SQL migration extension for Azure Data Studio instead, which supports both online and offline database migrations to Azure SQL Managed Instance.

Answer A: Always On availability groups. Why? The clue is: "The solution must minimize downtime and prevent data loss." For reference see: https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-overview?view=azuresql#compare-migration-options Migration option: Link feature for Azure SQL Managed Instance

Answer is B (Backup and Restore) because that's the ONLY viable option in the provided multiple choices for DB migration from ONprem to Azure SQL MI Below shown is a statement from Microsoft URL (highlighted in purple in website): DMA (data migration assistant) does not support database migrations to Azure SQL Managed Instance. Use the Azure SQL migration extension for Azure Data Studio instead, which supports both online and offline database migrations to Azure SQL Managed Instance. https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver16

DMA does not support migration to MI

Backup and restore is for now only option from given.

DMA DOES support migration to SQL MI (SMB share), so answer is correct.