exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 3 question 13 discussion

Actual exam question from Microsoft's AZ-305
Question #: 13
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 Managed Instance Business Critical
  • 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 🗳️

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
ckyap
Highly Voted 2 years ago
It came out in the exam today at 1st Dec22, I selected B, should be correct
upvoted 31 times
...
Gowind2
Highly Voted 2 years, 2 months ago
Selected Answer: B
https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell Zone-redundant configuration is not available in SQL Managed Instance. In SQL Database this feature is only available when the Gen5 hardware is selected. To prevent Data Loss, Premium/Business Critical is required: The primary node constantly pushes changes to the secondary nodes in order and ensures that the data is persisted to at least one secondary replica before committing each transaction. This process guarantees that if the primary node crashes for any reason, there is always a fully synchronized node to fail over to.
upvoted 21 times
mufflon
2 years, 2 months ago
Yes, of the selectable alternatives, it can only be premium
upvoted 1 times
...
randomGame
2 years ago
Today (20th nov. 2022), ZRS is in preview with SQL MI. "This feature is currently in preview for SQL Managed Instance, and only available on the Business Critical service tier. In SQL Database, when using the Business Critical tier, zone-redundant configuration is only available when the Gen5 hardware is selected." https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#premium-and-business-critical-service-tier-zone-redundant-availability
upvoted 6 times
...
...
SeMo0o0o0o
Most Recent 3 weeks, 2 days ago
Selected Answer: B
B is correct
upvoted 1 times
...
Lazylinux
7 months, 4 weeks ago
I would go for Azure SQL Database Premium (B) based on below Zone-redundant availability is available to databases in the Premium, Business Critical, General Purpose and Hyperscale service tiers, and not the Basic and Standard service tiers of the DTU-based purchasing model. Each service tier implements zone-redundant availability differently. This brings B and D in competition, however cost minimized B is winner based on this and you can sun cost calculator https://learn.microsoft.com/en-us/answers/questions/1057631/azure-sql-db-vs-azure-sql-managed-instance-cost
upvoted 4 times
...
Kaps19
8 months, 1 week ago
Answer is D: Zone-redundant configuration is in public preview for the General Purpose service tier and generally available for the Business Critical service tier.
upvoted 1 times
...
Markoduk
8 months, 2 weeks ago
Selected Answer: D
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql-mi&preserve-view=true https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql-mi&preserve-view=true#supported-regions-for-business-critical-instances Supported regions for Business Critical instances Zone redundancy for Business Critical SQL Managed Instance is supported in the following regions: D is correct
upvoted 1 times
...
ahmedkmj
8 months, 3 weeks ago
Not sure why its not D, I can see that SQL MI is supporting ZRS https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql
upvoted 1 times
Joonzz
8 months, 2 weeks ago
perhaps of this > https://azure.microsoft.com/en-us/updates/public-preview-azure-sql-updates-for-midmarch-2024/. I would say MI General Purpose - not sure about min cost
upvoted 1 times
...
...
kingfighers
10 months, 1 week ago
when I see this: Costs must be minimized, the first thing is remove D. Azure SQL Managed Instance General Purpose out of my choice..
upvoted 2 times
...
David_Webb
10 months, 3 weeks ago
Selected Answer: A
A. Azure SQL Managed Instance Business Critical There are zone redundant features on Azure SQL Managed Instance. To enable Zone redundant computing, the selected backup storage redundancy must be ZRS or GZRS. With the right configuration, you can have zone redundant on SQL Managed Instance. As of today, Zone redundancy for the General Purpose service tier is currently in preview. Thus, I would pick A as the correct answer. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql
upvoted 3 times
David_Webb
10 months, 3 weeks ago
Sorry, the answer should be B and must be SQL Database Premium. Since one of the requirements is to minimize the cost and SQL Database Premium is cheaper than Azure SQL Managed Instance Business Critical.
upvoted 2 times
...
...
BShelat
12 months ago
"B" should be the answer as ZRS configuration is still in public preview stage for Azure SQL Managed instance General Purpose.
upvoted 1 times
...
mmarkiew
1 year ago
The answer is B. Azure SQL Database: 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. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#zone-redundant-availability Azure SQL Managed Instance: Zone-redundant configuration is in public preview for the General Purpose service tier. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql#supported-regions-for-general-purpose-instances
upvoted 1 times
...
mark_af
1 year ago
Selected Answer: B
Its B, check this source: https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell A/D - SQL MI doesnt provide zone redundancy C - Basic doesnt provide zore redundancy
upvoted 4 times
mmarkiew
1 year ago
Agree that the answer is B, but to clarify, SQL MI does in fact support zone redundancy. However, this feature is in preview for the General Purpose service tier as of Nov 2023. Source: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql#supported-regions-for-general-purpose-instances
upvoted 1 times
...
...
christhai
1 year, 1 month ago
B IS CORRECT
upvoted 1 times
...
ArunS005
1 year, 2 months ago
Selected Answer: B
The correct answer is B "Azure SQL Database Premium".
upvoted 2 times
...
ntma3b
1 year, 2 months ago
B is the correct answer. Zone-redundant is currently in preview for SQL Managed Instance, and is only available for the Business Critical service tier. D - SQL Managed Instance General Purpose does not support Zone-redundant as of now. So it is out of the question.
upvoted 1 times
...
Leocan
1 year, 2 months ago
Selected Answer: B
B is the correct answer.
upvoted 1 times
...
NotMeAnyWay
1 year, 8 months ago
Selected Answer: B
The best option would be B. **Azure SQL Database Premium**. It provides high availability and failover capabilities, including the ability to remain available in the event of a zone outage, and supports failover between replicas without any data loss. Additionally, it provides a good balance of availability and cost, making it the most cost-effective option among the choices that still meets the requirements for high availability and failover.
upvoted 6 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 ...