You need to design a highly available Azure SQL database that meets the following requirements:
• Failover between replicas of the database must occur without any data loss.
• The database must remain available in the event of a zone outage.
• Costs must be minimized.
Which deployment option should you use?
To design a highly available Azure SQL database that must failover between replicas without data loss and remain available during a zone outage while minimizing costs, the best option is Azure SQL Database Business Critical. This tier provides automatic failover within the same region without any data loss and supports zone-redundant configurations, ensuring availability even during zone outages. Although it might not be the cheapest option, it meets all the specified requirements for availability and data integrity.
I think B based on cost
Database premium is cheaper B
B should be the correct answer.
The answer is incorrect. B is the correct answer. After dozens of variations of this question. How can it be? Really.
Can someone confirm the correct answer please.
What about recent update ? Improve the resiliency of your General Purpose Azure SQL Managed Instances by upgrading to a zone-redundant configuration. https://azure.microsoft.com/en-au/updates/public-preview-azure-sql-updates-for-midmarch-2024/
Still costs are Serverless < Premium DTU < General Purpose < General Purpose MI < Business Critical
While the General Purpose tier now supports zone-redundant configuration, it does not guarantee zero data loss in the event of a failover. The Business Critical tier, on the other hand, provides automatic failover within the same region without any data loss, which is one of your requirements.
Premium is cheaper than Business Critical that is cheaper than Hyperscale