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…

Question

Options

• Adatabase mirroring on an instance of SQL Server on Azure Virtual Machines
• Bavailability groups for SQL Server on Azure Virtual Machines
• Can Azure SQL Managed Instance link
• Dtransactional replication to an Azure SQL Managed Instance

• A
  3% (1)
• B
  6% (2)
• C
  16% (5)
• D
  74% (23)

Explanation

Transactional replication to Azure SQL Managed Instance (Option D) is the best fit because it supports near-real-time, continuous data replication from an on-premises SQL Server to Azure, uses a fully managed PaaS service (minimizing administrative overhead), and is cost-effective since you don't need to manage underlying VMs or OS infrastructure.

Why the distractors are wrong:

• Option A (Database Mirroring) is a deprecated feature in SQL Server and requires managing SQL Server on Azure VMs, increasing both cost and administrative burden.
• Option B (Availability Groups on Azure VMs) is a high-availability solution but requires configuring and maintaining Azure Virtual Machines, which significantly increases administrative effort and cost compared to a managed service.
• Option C (Azure SQL Managed Instance Link) provides replication but is primarily designed for online migration and hybrid scenarios rather than a sustained, cost-optimized disaster recovery setup with real-time replication.

Memory Tip: Think of "Transactional = Real-Time + Managed" - whenever a question mentions real-time replication to Azure with minimal admin effort, favor managed PaaS targets (like SQL Managed Instance) over VM-based solutions, and choose transactional replication for continuous, low-latency data movement.

No community discussion yet for this question.