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?
Azure SQL Database Business Critical is designed specifically for high availability and minimal downtime, even in the event of a zone outage. It offers premium failover capabilities with no data loss, which is essential for maintaining data integrity and availability in critical scenarios. While Serverless options are optimized for cost savings and variable workloads, they do not provide the same level of high availability and data protection as the Business Critical tier.
There are *16* variations of this question. Each of them offering different possible answers. The answer priority is as follows. If it exists then choose it. If it doesn't, proceeded to the next priority. Sometimes both appear in the same question, so make sure to select the higher priority. 1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical
It is true, thanks yonie.
thanks yonie
Good stuff yonie, you beat me to it.
D. Azure SQL Database Business Critical Azure SQL Database Serverless is a good option for workloads that experience variable or unpredictable traffic. However, it does not offer the same level of high availability as Azure SQL Database Business Critical.
Several times repeated and now the answer is A. It should be D.
I take it back. the order is Premium - Serverless - Business Critical. Answer is right. A.
Final Answer: Cost Of : Premium < Serverless < Business Critical < HyperScale
1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical
should be D
This is another duplicate question.
Azure SQL Database Serverless is the one
Serverless is a better answer than Business Critical.
No serverless can not guarantee no data loss failover
Serverless.
Why these question is constantly repeating? last 10x times a correct answer on the same question was "Azure SQL Database Business Critical"
It should be D, Serverless is an vCore-based Purchasing Model Plan. For ensuring failover without data loss and maintaining availability during zone outages go: Azure SQL Managed Instance Business Critical. Serverless is designed for cost savings and is more suited for workloads with intermittent, unpredictable usage patterns.
Azure SQL Database Business Critical*
Cost Of : Premium < Serverless < Business Critical < HyperScale
I would go for D but im as confused as hell and honestly when we do this in real life we have all resources from People, online doc etc and even discuss with MS... this is the ONLY question i see answers split 50% for A and 50% for D...Now i conclude that Microsoft is truly a lame duck :)...
I would go for this serie of question with this priority order Premium , serverless , business Critical In this case Serverless
thanks a lot yonie,
The general purpose service tier zone redundant availability is only available in some regions, not all of the regions: https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#general-purpose-service-tier-zone-redundant-availability