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

Exam AZ-304 All Questions

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

Exam AZ-304 topic 4 question 21 discussion

Actual exam question from Microsoft's AZ-304
Question #: 21
Topic #: 4
[All AZ-304 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 Standard
  • B. Azure SQL Database Serverless
  • C. Azure SQL Database Business Critical
  • D. Azure SQL Database Basic
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by adsdadasdad at Sept. 28, 2021, 8:47 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
poplovic
Highly Voted 3 years, 9 months ago
C is correct. It must be business critical for zone outage. Higher availability - Business Critical tier in Multi-AZ configuration guarantees 99.995% availability, compared to 99.99% of General Purpose tier. see https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla#premium-and-business-critical-service-tier-availability https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-business-critical
upvoted 17 times
roky
3 years, 9 months ago
agree with you
upvoted 3 times
...
rdemontis
3 years, 7 months ago
Yes, you are right, as DTU-based purchasing model you have to choose Premium for Service tier, otherwise you can choose General Purpose or Business Critical if the purchasing model is vCore-based. Since there isn't here the general purpose choice the only one suitable is Business Critical
upvoted 1 times
examineezer
3 years, 6 months ago
In preview for Generaly Purpose
upvoted 1 times
...
...
...
waxil
Highly Voted 3 years, 8 months ago
Was in the exam today, but Standard wasn't an option, instead it was premium
upvoted 6 times
MasterArmSwitch
3 years, 7 months ago
Hmm, that changes things a bit. https://techcommunity.microsoft.com/t5/azure/azure-sql-database-now-offers-zone-redundant-premium-databases/m-p/168963
upvoted 2 times
...
...
seaman33
Most Recent 6 months, 1 week ago
Selected Answer: C
"without any data loss" means business critical
upvoted 1 times
...
Fal991l
2 years, 8 months ago
Selected Answer: B
serverless makes more sense
upvoted 2 times
...
Snownoodles
2 years, 8 months ago
Selected Answer: B
General Purpose service tier zone redundant is publicly available already. Zone-redundant configuration for the General Purpose service tier is offered for both serverless and provisioned compute. Without usage pattern, it's hard to tell which is cheaper between Azure SQL database provisioning and serverless. In general, serverless should be cheaper since this is it's selling point comparing with provisioning database.
upvoted 2 times
...
ezfix
2 years, 9 months ago
B. SQL Database serverless (General Purpose) is cheaper than Business critical. Both Basic & Standard tiers support locally redundant availability. General Purpose (provisioned compute and serverless) support both locally redundant and zone redundant availability. Premium and Business Critical support both locally redundant and zone redundant (SQL AO group). https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell
upvoted 3 times
...
Snownoodles
2 years, 10 months ago
Selected Answer: A
The correct answer is A. 1) Azure SQL database standard = Azure SQL Database General Purpose service tier Azure SQL Database General Purpose service tier support Zone: "General Purpose service tier zone redundant availability" https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla T
upvoted 1 times
Snownoodles
2 years, 10 months ago
Service tiers: Azure SQL Database offers three service tiers: The General Purpose/Standard service tier is designed for common workloads. It offers budget-oriented balanced compute and storage options. The Business Critical/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. The Hyperscale service tier is designed for most business workloads. Hyperscale provides great flexibility and high performance with independently scalable compute and storage resources. It offers higher resilience to failures by allowing configuration of more than one isolated database replica. https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql#sql-database-frequently-asked-questions
upvoted 1 times
...
...
bacug
3 years, 5 months ago
Selected Answer: A
There are two high availability architectural models: Standard availability model that is based on a separation of compute and storage. It relies on high availability and reliability of the remote storage tier. This architecture targets budget-oriented business applications that can tolerate some performance degradation during maintenance activities. Premium availability model that is based on a cluster of database engine processes. It relies on the fact that there is always a quorum of available database engine nodes. This architecture targets mission-critical applications with high IO performance, high transaction rate and guarantees minimal performance impact to your workload during maintenance activities.
upvoted 3 times
...
xyz213
3 years, 5 months ago
Selected Answer: C
C is correct. It must be business critical for zone outage. Higher availability - Business Critical tier in Multi-AZ configuration guarantees 99.995% availability, compared to 99.99% of General Purpose tier. see https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla#premium-and-business-critical-service-tier-availability https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-business-critical
upvoted 1 times
...
xyz213
3 years, 5 months ago
Selected Answer: C
C is correct
upvoted 1 times
...
mtk93
3 years, 6 months ago
Selected Answer: C
C is ccorect
upvoted 1 times
...
donathon
3 years, 6 months ago
Selected Answer: C
C is correct
upvoted 2 times
...
HenryNguyen
3 years, 8 months ago
What a stupid question :)) . I wonder how cost is minimized but it require to have zone outage without any data loss =))
upvoted 3 times
examineezer
3 years, 6 months ago
Mimized isn't the same as cheap. Buying a yacht for 10 million instead of 50 million is minimizing costs.
upvoted 3 times
...
...
syu31svc
3 years, 9 months ago
https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla#premium-and-business-critical-service-tier-zone-redundant-availability 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. This feature is not available in SQL Managed Instance. C is the answer
upvoted 5 times
...
adsdadasdad
3 years, 9 months ago
Azure SQL Database Business Critical , they deleted the previous discussion .
upvoted 1 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