Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 2 question 16 discussion

Actual exam question from Microsoft's AZ-305

Question #: 16
Topic #: 2

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 Hyperscale
B. Azure SQL Database Premium
C. Azure SQL Database Basic
D. Azure SQL Managed Instance General Purpose

Show Suggested Answer

Suggested Answer: B 🗳️

by Gowind at Sept. 2, 2022, 3:10 p.m.

Comments

Submit Cancel

jellybiscuit

Highly Voted 2 years, 9 months ago

Selected Answer: B

I had a near-impossible time finding documentation for this, so I just went to my own portal and checked. SQL Database options that support Geo Redundancy vCore model - General Purpose (at additional cost) - Business Critical DTU model - Premium SQL MI does not support geo-redundancy at all.

upvoted 21 times

AdventureChick

1 year, 8 months ago

Sept 25, 2023. There are 2 errors in jellybiscuit's comment: 1) the scenario calls for Zone redundancy (handle a zone outage). It does not require Geo redundancy 2) Managed Instances now allow Zone Redundant (ZRS), Geo Redundant (GRS), and Geo Zone Redundant (GZRS). It depends on the Region, but the scenario does not include a Region. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automated-backups-overview?view=azuresql So both MI & SQL DB Premium will work, but SQL DB premium is considerably less expensive. I tried both in the Azure Pricing Calculator (Zone redudant & different sizes). SQL DB Premium is always far cheaper than Managed Instance. Azure Pricing Calculator: https://azure.microsoft.com/en-us/pricing/calculator/

upvoted 19 times

...

Gowind

Highly Voted 2 years, 9 months ago

Selected Answer: B

Answer is correct but explanation is wrong for C. You need General Purpose level as a minimum, not premium. https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell NB: Zone-redundant configuration is not available in SQL Managed Instance. In SQL Database this feature is only available when the Gen5 hardware is selected.

upvoted 15 times

...

[Removed]

Most Recent 7 months, 1 week ago

Selected Answer: B

B 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 3 times

...

[Removed]

7 months, 1 week ago

Selected Answer: B

B is correct

upvoted 2 times

...

tatacsi

1 year, 4 months ago

I am curious how can be compared the prices of DTU and vCore based solutions without describing any further needs? I created the below order based on https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/single/ -- Azure SQL Database Standard (DTU-based; Zone Redundancy not fully available) -- Azure SQL Database Hyperscale (vCore-based) -- Azure SQL Database General Purpose (vCore-based) -- Azure SQL Database Premium (DTU-based) -- Azure SQL Database Business Critical (vCore-based) & Azure SQL Database Basic does not provide zone redundancy at all.

upvoted 1 times

...

randy0077

1 year, 7 months ago

I think A is correct answer to support automatic failover with no dataloss.

upvoted 1 times

...

Sarankrish

1 year, 10 months ago

why not Azure SQL Database basic? Also, I don't find the option to specify basic or premium!!!

upvoted 2 times

AdventureChick

1 year, 8 months ago

Azure SQL DB - Basic & Standard only have LRS. They do not have ZRS (which is required by the scenario). The other Azure SQL DB service tiers have ZRS: DTU (Premium) and vCore (General Purpose, Business Critical, and Hyperscale) https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell

upvoted 2 times

MAKH83

1 year, 5 months ago

According to this article, basic and standard both support ZRS: https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu?view=azuresql

upvoted 1 times

mr_m_plow

1 year, 5 months ago

I think that's for backups only. According to this articale, ZRS is only supported on Azure SQL Premium: https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell

upvoted 3 times

...

SDiwan

1 year, 4 months ago

Basic supports ZRS and GRS for its backup and not for the database itself.

upvoted 1 times

...

ZUMY

2 years, 1 month ago

Answer is correct Azure SQL Managed Instance also offers high availability and disaster recovery capabilities, but it does not support zone redundant configuration. Instead, it uses a different approach called instance failover groups to provide high availability across different regions. Instance failover groups enable you to create and manage groups of managed instances that fail over together during a regional outage, allowing you to maintain availability of your database workloads.

upvoted 2 times

...

winy

2 years, 2 months ago

this was in the exam on 01/04/2023

upvoted 4 times

...

NotMeAnyWay

2 years, 3 months ago

Selected Answer: B

B. Azure SQL Database Premium To meet the requirements of a highly available Azure SQL database with no data loss during failover and availability during a zone outage, you should use Azure SQL Database Premium. The Premium tier provides built-in support for active geo-replication, which allows you to create readable secondary replicas in different regions, ensuring the database remains available in the event of a zone outage. Additionally, the Premium tier offers better performance and more resources compared to the Basic and General Purpose tiers, while Hyperscale, although highly scalable, can be more costly than the Premium tier.

upvoted 5 times

...

zellck

2 years, 4 months ago

Selected Answer: B

B is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql#service-tiers The Premium service tier is designed for OLTP applications with high transaction rates and low latency I/O requirements. It offers the highest resilience to failures by using several isolated replicas.

upvoted 4 times

...

OPT_001122

2 years, 4 months ago

Selected Answer: B

B. Azure SQL Database Premium

upvoted 2 times

...

annabelbm

2 years, 4 months ago

Zone-redundant configuration is currently in preview for SQL Managed Instance, and only available for the Business Critical service tier. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell

upvoted 1 times

...

Snownoodles

2 years, 9 months ago

B is correct If D is "Azure SQL DATABASE General Purpose", then D is correct. Azure SQL database general purpose support Zone but Azure MI general purpose doesn't support zone redundancy.

upvoted 3 times

...