Exam AZ-305 topic 3 question 16 discussion

Where are you mlantonis

Both AZ sql database standard and serverless(both are general purpose) support zone redundancy. It's hard to compare cost between AZ database standard and AZ database serverless without a usage patterns. In general, we can say Az database serverless is cost-effective. So the given answer might be correct.

DTU model (Basic and Standard dosen't explicitely have Zone Redundancy options but a 99.99% SLA which implies it), and vCore Business Critical does. I will go with C.

Serverless > B. Critical

1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical

A is correct

A is correct This Question has 3 answers based on the priority: 1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical

B is correct

Order to choose is Premium, Serverless, Business Critical

B is Honey availability = Three replicas, one read-scale replica, zone-redundant high availability (HA)

Azure SQL Database Business Critical is cheaper.

its either A or B also serverless is a compute tier not performance tier both general purpose or hyperscale supports surverless deployments.

Zone-redundant availability is available to databases in the General Purpose, Premium, Business Critical and Hyperscale service tiers of the vCore purchasing model, and not the Basic and Standard service tiers of the DTU-based purchasing model. Zone-redundant availability ensures Recovery Point Objective (RPO) which indicates the amount of data loss is zero. Taken from: https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#:~:text=ensures%20Recovery%20Point%20Objective%20(RPO)%20which%20indicates%20the%20amount-,of%20data%20loss,-is%20zero.

Premium -> Serverless -> BC, that's the preferred order.

Zone-redundant configuration for the General Purpose service tier is offered for both serverless and provisioned compute for databases in vCore purchasing model. Serverless is assumed to be cheaper https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell

The best option for your requirements would be **B. Azure SQL Database Business Critical**. This tier supports local redundancy within an Azure region and provides the highest resilience to failures, with multiple readable replicas, and failover with no data loss. It's designed for applications that require low-latency responses and high transaction rates, and it also provides the highest level of business continuity capabilities, which aligns with your requirement for the database to remain available in the event of a zone outage. However, it's important to note that while the Business Critical tier provides the highest level of performance and availability, it also comes with higher costs compared to other tiers. Therefore, it's crucial to balance your specific needs and budget when making a decision.

Azure SQL Database Business Critical is the only service tier that meets all the requirements. It provides high availability and performance by using local SSD storage and a cluster of database replicas. It supports zone redundancy, which means that the replicas are distributed across different availability zones within the same region. It also supports automatic failover with zero data loss guarantee. However, it is also the most expensive service tier among the options. Azure SQL Database Serverless does not meet the requirement of zero data loss failover, as it uses the General Purpose service tier under the hood. It also does not support zone redundancy. It is a cost-effective option for intermittent and unpredictable workloads, as it scales compute resources based on usage and pauses the database when inactive.