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 ensures failover between replicas occurs without data loss and remains available during a zone outage while minimizing costs, the best option is Azure SQL Database Business Critical. This tier offers high availability with automatic failover and zone redundancy, ensuring no data loss and continuous availability during outages. Azure SQL Managed Instance Business Critical also provides these features but typically at a higher cost. Basic and Standard tiers do not meet the high availability and failover requirements specified.
SQL Database Business Critical as it's cheaper than Managed Instance Business Critical
How many copies of this question ET is going to post here. That is the question.
This is repetition . In some cases I saw options for premium. Premium is cheaper than business critical ? can anyone clarify