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 73 discussion

Actual exam question from Microsoft's AZ-305
Question #: 73
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 Business Critical
  • B. Azure SQL Managed Instance Business Critical
  • C. Azure SQL Database Standard
  • D. Azure SQL Managed Instance General Purpose
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by ServerBrain at Jan. 5, 2023, 3:59 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
[Removed]
3 months, 3 weeks ago
Selected Answer: A
A is correct
upvoted 2 times
...
Lazylinux
10 months, 2 weeks ago
Selected Answer: A
A is correct Business Critical (Highest availability and performance): Offers business applications the highest resilience to failures by using several high availability secondary replicas, and provides the highest I/O performance. The Business Critical service tier is designed for applications that require low-latency responses from the underlying SSD storage (1-2 ms in average), faster recovery if the underlying infrastructure fails, or need to off-load reports, analytics, and read-only queries to the free of charge readable secondary replica of the primary database. Availability => Three replicas, one read-scale replica and zone-redundant high availability (HA)
upvoted 1 times
...
OrangeSG
1 year, 4 months ago
Selected Answer: A
C is wrong option because Azure SQL Database Standard do not have Zone-redundant availability. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#zone-redundant-availability 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. Zone-redundant availability ensures Recovery Point Objective (RPO) which indicates the amount of data loss is zero.
upvoted 2 times
...
zellck
2 years ago
Same as Question 84. https://www.examtopics.com/discussions/microsoft/view/99751-exam-az-305-topic-4-question-84-discussion
upvoted 3 times
...
zellck
2 years ago
Selected Answer: A
A 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 4 times
zellck
2 years 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 2 times
...
...
CloudK
2 years ago
Selected Answer: A
From: https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell Zone-redundant configuration is currently in preview for SQL Managed Instance, and ONLY available for the Business Critical service tier. I think that for a production service it is correct to use a service that is not in preview, so the correct answer should be "A"
upvoted 1 times
...
Mangocurry
2 years ago
Selected Answer: C
I think this should be C, General Purpose with ZRS.
upvoted 2 times
Mangocurry
2 years ago
Actually this is wrong. Standard falls under DTU based purchasing model and does not support ZRS. Standard != General Purpose
upvoted 3 times
...
zellck
2 years 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 1 times
...
...
clueless888
2 years ago
From what I heave read GeneralPurpose(aka Standard) supports ZRS There are three architectural models that are used in Azure SQL Database: • General Purpose/Standard • Business Critical/Premium • Hyperscale https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell
upvoted 4 times
Lu5ck
2 years ago
MI GP does but not available world wide yet thus the safest choice is as stated.
upvoted 1 times
...
...
yeanlingmedal71
2 years, 1 month ago
Selected Answer: A
Duplicate
upvoted 2 times
...
RandomNickname
2 years, 1 month ago
Selected Answer: A
For no data-loss and as per mVic A is correct.
upvoted 1 times
...
mVic
2 years, 1 month ago
Selected Answer: A
for these questions where zone-redundancy is required, there are only these options: -General Purpose -Premium -Business Critical https://learn.microsoft.com/en-GB/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell
upvoted 2 times
...
ServerBrain
2 years, 1 month ago
Selected Answer: A
Correct, In the absence of Azure SQL Database Premium
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago