Exam DP-300 topic 6 question 41 discussion

As of August 2023, C will become the new answer (Managed Instance Link): https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-feature-overview?view=azuresql-mi. It currently works as a DR solution ONLY for SQL Server 2022, so you need to pay attention to that aspect in the exam. If nothing else is specified, then D (replication) can be a solution. Mirroring and AlwaysON AGs: Mirroring is deprecated, so no go there. AG: can be a solution, but not minimizing costs and administration. To conclude: D is the answer if no version is specified for SQL Server, C is the answer if the question will say we're talking SQL Server 2022.

I would go with C: Link to Azure SQL MI. It can be certainly easier to configure Link rather than Transactional replication, and in terms of further administration and maintenance Transactional replication can be pain in the a**.

Take note, with Azure Managed Instance if you set it as a DR then you get a discount in costs - this sways it for me over transaction replication as minimizing cost is one of the requirements.

The best solution that I see is transactional replication.

i think C. The Managed Instance link feature uses distributed availability groups to extend your SQL Server on-premises Always On availability group hosted anywhere to Azure SQL Managed Instance in a safe and secure manner, replicating data in near real-time.