Ref: https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql
Basic Concept: This question tests choosing the correct Azure migration approach by matching the source platform, target service, downtime tolerance, and administrative effort.
Why D is Correct: Database Migration Assistant is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. In this scenario, the important constraint is: What should you use to minimize downtime and data loss during the migration? Database Migration Assistant satisfies that constraint without adding an unrelated service or manual process.
Why A is Wrong: distributed availability groups is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. It would solve a neighboring problem, but not the deployment, sizing, or migration requirement in this item.
Why B is Wrong: database mirroring is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. It mismatches the target platform, migration method, compute tier, or deployment model described in the scenario, so it would not satisfy the workload as stated.
Why C is Wrong: Log shipping is a SQL Server HA/DR technique that copies and restores log backups to a secondary database; it is more manual and operationally heavier for Azure SQL Managed Instance migration than LRS. It applies to a different Azure data-platform design than the one the question is testing.
