exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 122 discussion

Actual exam question from Microsoft's AZ-305
Question #: 122
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 Database Premium
  • C. Azure SQL Database Basic
  • D. Azure SQL Database Hyperscale
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
profesorklaus
4 months, 2 weeks ago
Selected Answer: B
B. Premium is cheaper than Business Critical and both fulfill all requirements.
upvoted 1 times
...
Tharassiyil
5 months ago
Can someone confirm the correct answer please.
upvoted 1 times
...
Lazylinux
7 months, 2 weeks ago
Selected Answer: B
I think B based on cost
upvoted 4 times
...
Joonzz
8 months, 3 weeks ago
What about recent update ? Improve the resiliency of your General Purpose Azure SQL Managed Instances by upgrading to a zone-redundant configuration. https://azure.microsoft.com/en-au/updates/public-preview-azure-sql-updates-for-midmarch-2024/
upvoted 1 times
LGWJ12
8 months ago
While the General Purpose tier now supports zone-redundant configuration, it does not guarantee zero data loss in the event of a failover. The Business Critical tier, on the other hand, provides automatic failover within the same region without any data loss, which is one of your requirements.
upvoted 2 times
...
rumino
8 months, 2 weeks ago
Still costs are Serverless < Premium DTU < General Purpose < General Purpose MI < Business Critical
upvoted 1 times
...
...
dejedi
8 months, 3 weeks ago
Selected Answer: B
Database premium is cheaper B
upvoted 3 times
...
rumino
9 months ago
Selected Answer: B
Premium is cheaper than Business Critical that is cheaper than Hyperscale
upvoted 1 times
...
Frank_2022
9 months ago
Selected Answer: B
B should be the correct answer.
upvoted 2 times
...
Crossfader2208
9 months ago
Selected Answer: B
The answer is incorrect. B is the correct answer. After dozens of variations of this question. How can it be? Really.
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
Loading ...