Question

You are deploying an Azure SQL Managed Instance to host a mission-critical order-processing application. The business requires that the database survive a single datacenter failure within the primary Azure region without any manual intervention or geo-failover to a secondary region. You must minimize cost while meeting this resiliency requirement. Which configuration should you choose?

Accepted Answer

Deploy the Business Critical service tier with zone redundancy enabled

Answer

Deploy the General Purpose service tier and configure an auto-failover group to a secondary region

Answer

Deploy the Business Critical service tier in a single availability zone and rely on automated backups

Answer

Deploy the General Purpose service tier with geo-replication to a paired region