DP-300 Certification Practice Question #246

Question

You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements:

•	Support real-time data replication to a different geographic region.
•	Use Azure as a disaster recovery target.
•	Minimize costs and administrative effort.

What should you include in the recommendation?

Accepted Answer

Although the legacy Suggested Answer and Most Voted is D (transactional replication), the introduction of the Azure SQL Managed Instance link (C) provides a modern, far superior solution. The Managed Instance link uses Distributed Availability Group technology to replicate databases in near real-time with minimal configuration and administrative overhead. In contrast, transactional replication (D) requires setting up and maintaining distributor databases, publishers, agents, and subscribers, which is notoriously difficult to maintain and doesn't support easy failover/failback operations. Therefore, C is the best answer that minimizes both costs and administrative effort.

More DP-300 practice questions