Design a highly available Azure SQL database with these requirements: lossless replica failover, availability during a zone outage, and minimal cost. Which deployment option should you choose?

Azure SQL Database Business Critical tier provides high availability with lossless replica failover and zone redundancy, ensuring availability during a zone outage. It uses multiple isolated replicas, including a primary and several readable secondary replicas, allowing for automatic failover with no data loss. This tier is also cost-effective compared to manually configuring and managing high availability solutions. Azure SQL Database Basic is not suitable as it lacks zone redundancy and offers limited availability. Azure SQL Managed Instance General Purpose does not inherently provide zone redundancy for its storage layer, making it less resilient to zone outages without additional configuration. Azure SQL Database Hyperscale offers high scalability but its availability model, while robust, might incur higher costs than Business Critical for the specified requirements.