exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 3 question 16 discussion

Actual exam question from Microsoft's AZ-305
Question #: 16
Topic #: 3
[All AZ-305 Questions]

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?

  • A. Azure SQL Database Serverless
  • B. Azure SQL Database Business Critical
  • C. Azure SQL Database Basic
  • D. Azure SQL Database Standard
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
marcelina50
Highly Voted 1 year, 7 months ago
Selected Answer: B
Where are you mlantonis
upvoted 122 times
Sr18
4 months, 4 weeks ago
Its BC for sure
upvoted 1 times
...
...
Snownoodles
Highly Voted 2 years, 3 months ago
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.
upvoted 30 times
leoletopic
1 year, 11 months ago
"Auto-failover groups support geo-replication of all databases in the group to only one secondary server in a different region" ,So ,if you need only one secondary server to support failover, you must use Geo-Redundancy. not Zone Redundancy. If you want in same regions ,you need more servers,which is not min cost https://learn.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-sql-db?view=azuresql&tabs=azure-powershell
upvoted 1 times
...
zellck
1 year, 9 months ago
Azure SQL DB Standard tier only supports LRS. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#basic-standard-and-general-purpose-service-tier-locally-redundant-availability
upvoted 2 times
...
sunis1
1 year, 1 month ago
While Azure SQL Database Serverless does offer cost savings, it may not meet your specific requirements for a few reasons: Data Loss: Azure SQL Database Serverless does not guarantee that committed data is never lost due to failures. This could potentially lead to data loss during failover, which does not align with your requirement for failover between replicas of the database to occur without any data loss. Availability during Zone Outages: While Azure SQL Database Serverless does provide automatic scaling and pausing/resuming of databases, it does not specifically guarantee availability in the event of a zone outage1.
upvoted 1 times
...
...
KapitanPletwal
Most Recent 1 day, 12 hours ago
Selected Answer: A
1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical
upvoted 1 times
...
Thanveer
1 week ago
Selected Answer: A
A is correct
upvoted 1 times
...
SeMo0o0o0o
2 weeks, 5 days ago
Selected Answer: A
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
upvoted 1 times
...
SeMo0o0o0o
3 weeks, 1 day ago
Selected Answer: B
B is correct
upvoted 1 times
SeMo0o0o0o
2 weeks, 5 days ago
after researches, A is correct as per priority it must be: 1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical
upvoted 1 times
...
...
CompetentNinja
1 month, 3 weeks ago
Selected Answer: A
Order to choose is Premium, Serverless, Business Critical
upvoted 3 times
...
Lazylinux
7 months, 3 weeks ago
Selected Answer: B
B is Honey availability = Three replicas, one read-scale replica, zone-redundant high availability (HA)
upvoted 2 times
...
LGWJ12
8 months, 1 week ago
Selected Answer: B
Azure SQL Database Business Critical is cheaper.
upvoted 3 times
...
hanoki6540
9 months, 1 week ago
its either A or B also serverless is a compute tier not performance tier both general purpose or hyperscale supports surverless deployments.
upvoted 1 times
...
WeepingMaplte
9 months, 3 weeks ago
Selected Answer: B
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.
upvoted 4 times
profesorklaus
7 months ago
Zone-Redundand is available in General Purpose Serverless. General Purpose is in Locally redundant availability model. Locally redundant availability is available to all databases in all service tiers and Recovery Point Objective (RPO) which indicates the amount of data loss is zero. So you are wrong.
upvoted 1 times
...
...
[Removed]
10 months, 3 weeks ago
Selected Answer: A
Premium -> Serverless -> BC, that's the preferred order.
upvoted 14 times
...
ziggy1117
12 months ago
Selected Answer: A
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
upvoted 4 times
profesorklaus
7 months ago
Agree. I checked in Azure Price Calculator. It seems event obvious to be cheaper by serveless as it requires less resources to be engaged
upvoted 1 times
...
Rouix
7 months, 4 weeks ago
Agree. Go here with Serverless option. Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose#regions-supporting-80-maximum-vcores-with-availability-zones-for-general-purpose
upvoted 1 times
...
...
Paul_white
1 year ago
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.
upvoted 1 times
...
StixxNSnares
1 year ago
Selected Answer: B
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.
upvoted 3 times
profesorklaus
7 months ago
Azure SQL Database Serverless meets the requirements of zero data loss failover as all service tiers work in locally redundant availability. Locally redundant availability is available to all databases in all service tiers and Recovery Point Objective (RPO) which indicates the amount of data loss is zero. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell
upvoted 1 times
ValB
2 months, 1 week ago
LRS is not enough, they explicitly stated that they want ZRS.
upvoted 1 times
...
...
...
GeorgiAngelov
1 year, 1 month ago
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.
upvoted 3 times
...
ArunS005
1 year, 1 month ago
Selected Answer: B
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
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...