Your environment contains a Microsoft Azure machine that has Microsoft SQL Server Standard installed. An application named App1 uses the data stored in SQL server. The Service level Agreement (SLA) for App1 states that the application can lose a maximum of 10 minutes of data and that the data must be available if two Azure regions fail. You need to implement a solution that provides disaster recovery for App1. In two other Azure regions, you deploy an Azure virtual machine that has SQL Server installed. What should you implement next?

Question

Accepted Answer

D. Log Shipping Log Shipping supports cross-region disaster recovery for SQL Server Standard Edition by periodically backing up transaction logs from the primary server and restoring them to one or more secondary servers. This method allows for a low Recovery Point Objective (RPO) within minutes and ensures data availability even if two Azure regions fail, by configuring multiple secondary servers.

Answer

A. Merge Replication Merge Replication is primarily designed for data synchronization in disconnected or occasionally connected environments and is not an optimal or robust solution for achieving low RPO disaster recovery for a critical application.

Answer

B. AlwaysOn Failover Cluster Instances AlwaysOn Failover Cluster Instances provide high availability within a single Windows Server Failover Cluster, typically across nodes in the same datacenter or region, but do not provide disaster recovery across multiple Azure regions.

Answer

C. AlwaysOn Availability Groups AlwaysOn Availability Groups are not available in SQL Server Standard Edition, which is specified in the question, and thus cannot be implemented.

Your environment contains a Microsoft Azure machine that has Microsoft SQL Server Standard installed. An application named App1 uses the data stored in SQL server. The Service level Agreement (SLA)…

Question

Options

How the community answered

Why each option

Topics

Community Discussion