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 4 question 84 discussion

Actual exam question from Microsoft's AZ-305
Question #: 84
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 Database Business Critical
  • C. Azure SQL Database Standard
  • D. Azure SQL Managed Instance General Purpose
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by pkkalra at Feb. 18, 2023, 6:57 a.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
NotMeAnyWay
Highly Voted 1 year, 12 months ago
Selected Answer: B
B. Azure SQL Database Business Critical Azure SQL Database Business Critical tier is designed to provide high availability with zero data loss during failover, which meets one of the main requirements of the scenario. Additionally, Azure SQL Database Business Critical tier offers zone redundant configurations, which means that replicas of the data are stored in different availability zones. This means the database will remain available in the event of a zone outage, meeting another requirement of the scenario. Azure SQL Managed Instance General Purpose, while providing automatic backups and high availability within a single region, doesn't support the required zone redundancy. Please note, while Business Critical tier might appear costly, the requirement is to minimize costs, not to choose the least costly option. Considering the high availability and zero data loss requirements, Business Critical tier would be the most cost-effective choice.
upvoted 10 times
...
[Removed]
Most Recent 7 months, 2 weeks ago
Selected Answer: B
B is correct
upvoted 2 times
...
rumino
1 year, 3 months ago
Selected Answer: D
Azure SQL Managed Instance General Purpose, as it's cheaper than Azure SQL Database Business Critical By selecting a zone-redundant configuration, you can make your Business Critical or General Purpose instances resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes to the application logic. You can also convert any existing Business Critical or General Purpose instances to zone-redundant configuration. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-sla?view=azuresql-mi&preserve-view=true
upvoted 4 times
LearnICC
11 months, 2 weeks ago
Zone-redundancy is currently in public preview for the General Purpose service tier (2024-07) - so you are right, but I don't think the exams rely on public previews, only on public available features: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-zone-redundancy-configure
upvoted 2 times
...
...
mariomishty
1 year, 6 months ago
D. Azure SQL Managed Instance General Purpose
upvoted 2 times
...
Tplenty
1 year, 7 months ago
It is a repeated question, the answer is B. Azure SQL Database Business Critical
upvoted 2 times
...
sainandam
2 years, 4 months ago
Selected Answer: C
Minimize costs
upvoted 1 times
zellck
2 years, 4 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 3 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 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 3 times
zellck
2 years, 4 months ago
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 By default, the cluster of nodes for the premium availability model is created in the same datacenter. With the introduction of Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated across multiple zones as three gateway rings (GW). The routing to a specific gateway ring is controlled by Azure Traffic Manager (ATM). Because the zone-redundant configuration in the Premium or Business Critical service tiers doesn't create additional database redundancy, you can enable it at no extra cost. By selecting a zone-redundant configuration, you can make your Premium or Business Critical databases resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes to the application logic.
upvoted 1 times
...
...
pkkalra
2 years, 4 months ago
Selected Answer: B
Azure SQL Database Business Critical
upvoted 2 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