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
Barry_Lammers_dwh
1 month, 2 weeks ago
Selected Answer: A
Failover between replicas of the database must occur without any data loss. Premium is about the computing node (DTU) while BC is about the HA functionality. So answer should be A
upvoted 1 times
...
7f3f6bd
4 months, 3 weeks 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 2 times
...
yyandrakk
6 months ago
Selected Answer: B
Remember: 1º Premium 2º Serverless 3º Business Critical
upvoted 4 times
Barry_Lammers_dwh
1 month, 2 weeks ago
Failover between replicas of the database must occur without any data loss. Premium is about the computing node (DTU) while BC is about the HA functionality. So answer should be A
upvoted 1 times
...
...
jbnkb
6 months, 1 week ago
Selected Answer: A
Only Business Critical makes guarantees for 0 data loss because it does synchronous replication.
upvoted 2 times
...
profesorklaus
11 months, 1 week ago
Selected Answer: B
B. Premium is cheaper than Business Critical and both fulfill all requirements.
upvoted 2 times
...
Tharassiyil
12 months ago
Can someone confirm the correct answer please.
upvoted 1 times
...
Lazylinux
1 year, 2 months ago
Selected Answer: B
I think B based on cost
upvoted 4 times
...
Joonzz
1 year, 3 months 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
1 year, 2 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
1 year, 3 months ago
Still costs are Serverless < Premium DTU < General Purpose < General Purpose MI < Business Critical
upvoted 1 times
...
...
dejedi
1 year, 3 months ago
Selected Answer: B
Database premium is cheaper B
upvoted 3 times
...
rumino
1 year, 3 months ago
Selected Answer: B
Premium is cheaper than Business Critical that is cheaper than Hyperscale
upvoted 1 times
...
Frank_2022
1 year, 3 months ago
Selected Answer: B
B should be the correct answer.
upvoted 2 times
...
Crossfader2208
1 year, 3 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