ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam
Go to Exam

Exam AZ-305 topic 2 question 16 discussion

Actual exam question from Microsoft's AZ-305
Question #: 16
Topic #: 2
[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 Hyperscale
  • B. Azure SQL Database Premium
  • C. Azure SQL Database Basic
  • D. Azure SQL Managed Instance General Purpose
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Gowind at Sept. 2, 2022, 3:10 p.m.

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
Submit Cancel
jellybiscuit
Highly Voted 2 years, 7 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, 7 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, 7 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 5 months, 2 weeks 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]
5 months, 2 weeks ago
Selected Answer: B
B is correct
upvoted 2 times
...
tatacsi
1 year, 2 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, 6 months ago
I think A is correct answer to support automatic failover with no dataloss.
upvoted 1 times
...
Sarankrish
1 year, 8 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, 7 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, 4 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, 3 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, 2 months ago
Basic supports ZRS and GRS for its backup and not for the database itself.
upvoted 1 times
...
...
...
...
ZUMY
1 year, 12 months 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 ago
this was in the exam on 01/04/2023
upvoted 4 times
...
NotMeAnyWay
2 years, 1 month 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, 2 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, 3 months ago
Selected Answer: B
B. Azure SQL Database Premium
upvoted 2 times
...
annabelbm
2 years, 3 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, 7 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
...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago