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 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 🗳️
by Crossfader2208 at March 7, 2024, 9:37 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
7f3f6bd
4 weeks, 1 day ago
Selected Answer: A
Business Critical is costlier than Basic but cheaper than Hyperscale for high availability. Premium is older terminology and Business Critical is the modern equivalent.
upvoted 1 times
...
yyandrakk
2 months ago
Selected Answer: B
Remember: 1º Premium 2º Serverless 3º Business Critical
upvoted 1 times
...
jbnkb
2 months, 1 week ago
Selected Answer: A
Only Business Critical makes guarantees for 0 data loss because it does synchronous replication.
upvoted 1 times
...
profesorklaus
7 months, 2 weeks ago
Selected Answer: B
B. Premium is cheaper than Business Critical and both fulfill all requirements.
upvoted 2 times
...
Tharassiyil
8 months ago
Can someone confirm the correct answer please.
upvoted 1 times
...
Lazylinux
10 months, 2 weeks ago
Selected Answer: B
I think B based on cost
upvoted 4 times
...
Joonzz
11 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
11 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
11 months, 2 weeks ago
Still costs are Serverless < Premium DTU < General Purpose < General Purpose MI < Business Critical
upvoted 1 times
...
...
dejedi
11 months, 3 weeks ago
Selected Answer: B
Database premium is cheaper B
upvoted 3 times
...
rumino
11 months, 4 weeks ago
Selected Answer: B
Premium is cheaper than Business Critical that is cheaper than Hyperscale
upvoted 1 times
...
Frank_2022
12 months ago
Selected Answer: B
B should be the correct answer.
upvoted 2 times
...
Crossfader2208
12 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago