You have an Azure subscription that contains an Azure SQL managed instance named Server1. You need to ensure the availaibility of Server1 if an Azure region fails. What should you do?

Question

Options

• AMigrate the databases hosted on Server1 to the Hyperscale service tier and enable locally-
• BCreate a failover group and deploy a logical server for Azure SQL Database to a different Azure
• CCreate a failover group and deploy a new SQL managed instance to a different Azure region.
• DCreate a read-only replica in a different Azure region and configure Server1 to use the replica.

• A
  4% (2)
• B
  10% (5)
• C
  84% (43)
• D
  2% (1)

Explanation

To protect an Azure SQL Managed Instance from Azure region failures, you should enable zone redundancy for high availability within the region and implement disaster recovery with failover groups to a secondary region. Zone redundancy ensures resilience to zonal outages, while failover groups enable failover to a secondary instance in case of a region-wide outage. 1. Zone Redundancy: Enable zone redundancy to ensure the managed instance is distributed across multiple availability zones within the same region. This provides redundancy against hardware and software failures in a single zone, maintaining high availability with up to 99.99% SLA. You can enable zone redundancy through the Azure portal or PowerShell. 2. Disaster Recovery with Failover Groups: Create a failover group that includes your primary managed instance and a secondary managed instance in a different region. The secondary instance serves as a failover target in case of a region-wide outage. Configure the failover group to replicate data continuously between the instances, ensuring minimal data loss during a failover. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/disaster-recovery-guidance

No community discussion yet for this question.