Design a highly available Azure SQL database with these requirements: failover between replicas must be lossless; the database must remain accessible during a zone outage; and cost should be minimized. Which deployment option meets these requirements?

Azure SQL Database Business Critical tier provides high availability through multiple synchronous replicas, ensuring lossless failover. It supports availability zones, allowing the database to remain accessible during a zone outage by automatically failing over to a replica in another zone. This tier is a cost-effective solution for these requirements compared to SQL Managed Instance, which has higher overhead. Azure SQL Database Hyperscale offers high scalability but its high availability model is different and might not guarantee lossless failover in all scenarios without additional configuration. Azure SQL Database Standard offers basic availability with less stringent RPO/RTO guarantees and does not inherently support zone redundancy for automatic failover during a zone outage.