You must design a highly available Azure SQL Database meeting these constraints: failover with no data loss, availability during a zonal outage, and minimized cost. Which deployment option satisfies these requirements?

Azure SQL Database Business Critical tier uses multiple replicas for high availability, including a readable secondary replica. This architecture ensures automatic failover with no data loss and provides zonal redundancy by default when deployed in regions supporting Availability Zones, protecting against zonal outages. Its integrated high availability and disaster recovery features are more cost-effective than manually configuring and managing these features with other options. Azure SQL Database Basic is a low-cost option but lacks the high availability and zonal redundancy required. Azure SQL Managed Instance General Purpose offers high availability but does not guarantee zero data loss on failover and lacks built-in zonal redundancy. Azure SQL Managed Instance Business Critical offers similar high availability and zero data loss as SQL Database Business Critical but is generally more expensive due to its instance-level capabilities, which are not explicitly required by the prompt.