exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 69 discussion

Actual exam question from Microsoft's AZ-305
Question #: 69
Topic #: 4
[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 Basic
  • B. Azure SQL Managed Instance General Purpose
  • C. Azure SQL Database Business Critical
  • D. Azure SQL Managed Instance Business Critical
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
zellck
Highly Voted 1 year, 9 months ago
Selected Answer: C
C is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql#service-tiers The Business Critical 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 10 times
...
SeMo0o0o0o
Most Recent 3 weeks ago
Selected Answer: C
C is correct 1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical
upvoted 2 times
...
rishisoft1
8 months, 3 weeks ago
C is the answer because Managed Instance SQL General Purpose is cheaper option but still zone redundancy is under preview. Here is Microsoft Document says "Zone redundancy for General Purpose service tier is currently in preview. "
upvoted 2 times
...
rumino
9 months ago
Selected Answer: B
SQL MI General Purpose is cheaper than SQL DB Business Critical failover without data loss is guaranteed DB remains available at zone outage, only performance can be degraded until the cache will fill
upvoted 2 times
rumino
9 months ago
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql-mi&preserve-view=true
upvoted 2 times
...
...
SDiwan
9 months, 2 weeks ago
Selected Answer: C
For high availability/no data loss related question, the answer is either Business Critical ( for vcore based) or Premium ( for DTU based)
upvoted 2 times
...
OrangeSG
1 year, 1 month ago
Selected Answer: C
B is wrong because Azure SQL Managed Instance General Purpose does not support Zone redundancy. Reference Migrate SQL Managed Instance to availability zone support https://learn.microsoft.com/en-us/azure/reliability/migrate-sql-managed-instance Prerequisites To migrate to availability-zone support: • Your instance must be running under Business Critical tier with the November 2022 feature wave update. • Confirm that your instance is located in a supported region. • Your instances must be running on standard-series (Gen5) hardware.
upvoted 3 times
...
Jools
1 year, 4 months ago
Selected Answer: C
C is the answer. Storage in the general purpose tier is LRS which is not resiliant in case of zone outage https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql-db&viewFallbackFrom=azuresql-mi&tabs=azure-powershell
upvoted 2 times
...
NotMeAnyWay
1 year, 4 months ago
Selected Answer: C
The best deployment option that meets all the requirements would be: C. Azure SQL Database Business Critical The Business Critical service tier is designed for applications that require low-latency responses and high transaction rates, and need the highest degree of resilience to failures. It supports multiple read-only replicas, and failover between replicas of the database occurs without any data loss. It is also designed to maintain availability in the event of a zone outage. While Azure SQL Managed Instance Business Critical also provides high availability and zero data loss, it generally costs more than Azure SQL Database Business Critical. Therefore, to minimize costs as per your requirement, Azure SQL Database Business Critical would be a better choice. Azure SQL Database Basic and Azure SQL Managed Instance General Purpose do not offer the same level of high availability and data resilience as the Business Critical options.
upvoted 2 times
...
lombri
1 year, 7 months ago
Selected Answer: B
Option B (Azure SQL Managed Instance General Purpose) best meets the stated requirements, as it supports automatic failover between replicas and ensures availability even in the event of a zone outage, at a lower cost than Option C, and D.
upvoted 2 times
lombri
1 year, 7 months ago
D. Azure SQL Managed Instance Business Critical. This option is designed for high availability and disaster recovery, with multiple replicas across different availability zones to ensure minimal data loss and downtime. The Business Critical service tier offers the highest resilience to failures and is specifically designed for OLTP applications with high transaction rates and low latency I/O requirements. Option C, Azure SQL Database Business Critical, only offers replication within the same region and does not provide zone redundancy.
upvoted 1 times
alexander_panfilenok
1 year, 5 months ago
Azure SQL Database Business Critical does provide Zone Redundancy: https://learn.microsoft.com/en-GB/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell
upvoted 2 times
...
...
...
zellck
1 year, 9 months ago
Same as Question 84. https://www.examtopics.com/discussions/microsoft/view/99751-exam-az-305-topic-4-question-84-discussion
upvoted 3 times
...
pkkalra
1 year, 9 months ago
Selected Answer: C
C. Azure SQL Database Business Critical
upvoted 3 times
...
_fvt
1 year, 9 months ago
Selected Answer: C
"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) So any Managed Instance option should yet not be an acceptable answer.
upvoted 3 times
_fvt
1 year, 9 months ago
Also Azure SQL Database Basic doesn't offer zone redundant availability so it can only be answer C: "Azure SQL Database Business Critical"
upvoted 1 times
...
...
Lu5ck
1 year, 10 months ago
Selected Answer: C
Hi guys, Managed Instance General Purpose zone redundant feature is not available world wide yet therefore I don't think is a "safe" answer. Therefore, it come down to C and D. Azure SQL Database Business Critical should be cheaper than Managed. I mean, managed is called managed for a reason even if you don't know the actual available specs. Upon googling, you will learn that Azure SQL Database Business Critical provide lower specs aka cheaper options than Managed.
upvoted 4 times
...
jingasloth
1 year, 10 months ago
ChatGPT says C - Azure SQL Database Business Critial
upvoted 4 times
ITboy8
1 year, 9 months ago
well, respect the chatGPT then. I will go with C
upvoted 1 times
...
...
OPT_001122
1 year, 10 months ago
Selected Answer: B
B. Azure SQL Managed Instance General Purpose
upvoted 1 times
OPT_001122
1 year, 10 months ago
this seems not to be the correct ans, Same question73 has a different ans and it is highly voted A. Azure SQL Database Business Critical
upvoted 1 times
...
...
Tralala182
1 year, 10 months ago
Chatgpt answer is D
upvoted 2 times
...
tfulanchan
1 year, 10 months ago
Selected Answer: C
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#general-purpose-service-tier-zone-redundant-availability
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago