Design a highly available Azure SQL database that must fail over between replicas with no data loss, remain available during an availability zone outage, and minimize costs. Which deployment option should you select?

The Azure SQL Database Premium service tier (and Business Critical) provides zone-redundant high availability, ensuring no data loss during failovers and continuous availability during an availability zone outage. It uses multiple synchronous replicas across availability zones. The Hyperscale service tier offers high scalability but its high availability model for zone redundancy involves asynchronous replicas, which can incur minimal data loss during a zone-wide outage. The Standard service tier uses locally redundant storage and does not provide zone-redundant high availability, meaning it would not remain available during an availability zone outage. Azure SQL Managed Instance (General Purpose) also uses locally redundant storage and does not support zone redundancy in its General Purpose tier, failing to meet the availability zone outage requirement.