Home » Microsoft » 70-473 v.2 » Which solutions should you include in the environment?
HOTSPOT
You need to design a highly available Microsoft SQL Server environment in Microsoft Azure that meets the following requirements:
Prevents data loss if an Azure data center becomes unavailable
Fails over to another Azure region without causing data loss if an Azure region becomes unavailable
Which solutions should you include in the environment? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Explanation/Reference:
Explanation:
Box 1: AlwaysOn Availability Groups
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.
Box 2: Availability Zones
Availability Zones is a high-availability offering that protects your applications and data from datacenter failures. Availability Zones are unique physical locations within an Azure region. Each zone is made up of one or more datacenters equipped with independent power, cooling, and networking. To ensure resiliency, there’s a minimum of three separate zones in all enabled regions. The physical separation of Availability Zones within a region protects applications and data from datacenter failures. Zone-redundant services replicate your applications and data across Availability Zones to protect from single-points-of-failure.
References:
https://docs.microsoft.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