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.

Business Critical tier uses synchronous replication across multiple zones, ensuring zero data loss during failover. - Why A is wrong: Serverless - Optimized for intermittent workloads but does not support zone redundancy or guaranteed failover without data loss.

Serverless is cost-effective and good for variable workloads, but lacks zone redundancy and synchronous replication — so failover can cause data loss. Business Critical supports zone redundancy and offers zero data loss with synchronous failover — it’s the right choice for high availability.

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

Answer is Correct Serverless and Standard: Offer high availability but typically rely on standard availability (within a single availability zone) and might have potential data loss during a zone-level failure.

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

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.

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.