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.

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.

To design a highly available Azure SQL database that meets the requirements of failover without data loss, availability during zone outages, and cost minimization, you should choose option B: Azure SQL Database Business Critical. Azure SQL Database Business Critical is designed for high availability and fault tolerance. It provides an SLA that ensures failover without data loss and remains available even in the event of a zone outage. This service tier is specifically designed for mission-critical workloads and offers replication of data across multiple availability zones. Options A (Azure SQL Database Serverless), C (Azure SQL Database Basic), and D (Azure SQL Database Standard) do not offer the same level of high availability, failover guarantees, and zone-resilience as Azure SQL Database Business Critical. Therefore, option B is the best choice for meeting the given requirements.

To meet the requirements of high availability, failover without data loss, and availability in the event of a zone outage, you should choose the Azure SQL Database Business Critical deployment option. So, the correct answer is: B. Azure SQL Database Business Critical