Your environment contains a Microsoft Azure virtual machin
e 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 ava
ilable 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?
A. Merge
Replication
B. AlwaysOn Failover Cluster Instances
C. AlwaysOn Availability Groups
D. Log Shipping
Explanation:
Availability Groups example: Availability replicas running across multiple datacenters in Azure VMs for disaster recovery. This cross
-region solution protects against complete site outage.
Note: Microsoft SQL Server AlwaysOn is a collection of high availability and disaster recovery features introduced from SQL Server 2012. AlwaysOn is used to minimize the Recovery Point Objective (RPO
) and Recovery Time Objective (RTO) and maximized availability databases. SQL Server AlwaysOn branding encompasses both FCIs (Failover Cluster) and AGs (Availability Group) an enterprise-level alternative to database mirroring.
References:
https://docs.m
icrosoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-high-availability-dr
https://docs.microsoft.com/en-us/azure/availability-zones/az-overview