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

Actual exam question from Microsoft's AZ-305
Question #: 99
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 Serverless
  • B. Azure SQL Managed Instance General Purpose
  • C. Azure SQL Database Basic
  • D. Azure SQL Database Business Critical
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by gca22 at April 23, 2023, 3:21 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
yonie
Highly Voted 2 years, 3 months ago
There are *16* variations of this question. Each of them offering different possible answers. The answer priority is as follows. If it exists then choose it. If it doesn't, proceeded to the next priority. Sometimes both appear in the same question, so make sure to select the higher priority. 1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical
upvoted 140 times
hotspot02103
3 months ago
give me btc address, wanna send u some, my hero
upvoted 1 times
...
HarryRhodes
1 year, 3 months ago
Good stuff yonie, you beat me to it.
upvoted 1 times
...
betterthanlife
2 years, 3 months ago
It is true, thanks yonie.
upvoted 4 times
...
SandCloud
2 years, 2 months ago
thanks yonie
upvoted 5 times
...
...
Azwscp2023
Highly Voted 1 year, 9 months ago
Selected Answer: D
D. Azure SQL Database Business Critical Azure SQL Database Serverless is a good option for workloads that experience variable or unpredictable traffic. However, it does not offer the same level of high availability as Azure SQL Database Business Critical.
upvoted 6 times
pra_nj
5 months ago
D. Azure SQL Database Business Critical Here's why: Failover Without Data Loss: The Business Critical tier uses synchronous replication, ensuring that failover between replicas occurs without any data loss. Zone Outage Resilience: It supports zone redundancy, ensuring that the database remains available even in the event of a zone outage. Cost Efficiency: While providing high availability and resilience, it is generally more cost-effective compared to other options that offer similar levels of availability and data integrity. This option balances high availability, data integrity, and cost efficiency, making it the most suitable choice for your requirements.
upvoted 2 times
...
...
Thameur01
Most Recent 1 week ago
Selected Answer: D
Serverless compute tier: auto-scales compute resources based on workload activity and bills for the amount of compute used, per second. The serverless compute tier is generally available in the General-Purpose service tier and is currently in preview in the Hyperscale service tier, no serverless for business critical. • ✅ Cost-effective for intermittent workloads • ❌ No zone redundancy available • ❌ Not built for high availability in the event of zone failure • ❌ Doesn’t guarantee zero data loss failover
upvoted 1 times
...
examtaker20398
2 weeks, 2 days ago
Selected Answer: D
Answer is D, serverless will not work
upvoted 1 times
...
155e6a0
1 month ago
Selected Answer: D
Checked with 4 AI bots, which all chose D. Azure SQL Database Business Critical. Here is why not A. Azure SQL Database Serverless: "High Availability/Data Loss: The Serverless tier uses the General Purpose architecture by default. While it offers high availability within a datacenter (local redundancy), it does not inherently provide zone redundancy unless explicitly configured. If you enable zone redundancy for Serverless (which is possible for the General Purpose tier), it will meet the zone outage requirement. However, Serverless is designed for intermittent, unpredictable workloads and can auto-pause, which introduces latency on first connection after a pause. This might not align with "failover without any data loss" in the sense of always-on availability without a potential initial connection timeout. It's more about cost-effectiveness for varying workloads, not necessarily the highest immediate availability during a failover compared to Business Critical."
upvoted 1 times
...
SardarAbdulBasit
2 months ago
Selected Answer: D
Answer is D
upvoted 1 times
...
abrakadabra200
2 months, 3 weeks ago
Selected Answer: A
1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical
upvoted 1 times
...
khaled_razouk
3 months ago
Selected Answer: D
Azure SQL Database Business Critical
upvoted 1 times
...
7f3f6bd
5 months, 4 weeks ago
Selected Answer: D
Business Critical is more expensive than Basic or General Purpose but is the cheapest option that meets all HA requirements.
upvoted 2 times
...
ArtCr
8 months, 3 weeks ago
Selected Answer: A
Lower cost
upvoted 2 times
...
_punky_
9 months, 1 week ago
Selected Answer: A
Serveless
upvoted 2 times
...
620b351
9 months, 2 weeks ago
Selected Answer: D
Just called Mlantonis, it's D.
upvoted 2 times
...
84e067a
9 months, 2 weeks ago
Selected Answer: D
D: Azure SQL Database Business Critical
upvoted 1 times
...
Teerawee
10 months, 3 weeks ago
Selected Answer: D
Azure SQL Database Business Critical
upvoted 1 times
...
e5469b9
11 months, 1 week ago
Selected Answer: A
Premium - Serverless - Critical, in that order
upvoted 4 times
...
OlehT
1 year ago
Selected Answer: D
It should be D, Serverless is an vCore-based Purchasing Model Plan. For ensuring failover without data loss and maintaining availability during zone outages go: Azure SQL Managed Instance Business Critical. Serverless is designed for cost savings and is more suited for workloads with intermittent, unpredictable usage patterns.
upvoted 2 times
OlehT
1 year ago
Azure SQL Database Business Critical*
upvoted 1 times
...
...
CharlesS76
1 year, 1 month ago
Selected Answer: A
Cost Of : Premium < Serverless < Business Critical < HyperScale
upvoted 4 times
...
Load full discussion...
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