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

Actual exam question from Microsoft's AZ-305
Question #: 125
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 Standard
  • B. Azure SQL Managed Instance Business Critical
  • C. Azure SQL Database Serverless
  • D. Azure SQL Database Premium
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Frank_2022 at March 8, 2024, 7 p.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
Frank_2022
Highly Voted 1 year, 2 months ago
Selected Answer: D
The given answer is wrong. It should be D (Azure SQL Database Remium).
upvoted 5 times
HarryRhodes
1 year, 1 month ago
Agreed. Only choose Business Critical in the absence of Premium in these questions.
upvoted 5 times
kasper89
10 months, 2 weeks ago
When to choose the Serverless pls?
upvoted 1 times
Gaz_
10 months, 2 weeks ago
Premium > Serverless > Business Critical, in that order based on minimized costs
upvoted 3 times
...
...
...
...
K777121
Most Recent 1 month, 2 weeks ago
Selected Answer: B
The correct answer is: B. Azure SQL Managed Instance Business Critical Explanation: Failover with no data loss: The Business Critical tier uses Always On Availability Groups, ensuring that failover between replicas occurs without data loss. Zone outage resilience: It supports zone-redundant configurations, which ensure database availability even during a zone outage. Cost Efficiency: While it provides high availability, it is a cost-effective solution compared to other premium tiers for databases requiring these features.
upvoted 1 times
...
profesorklaus
9 months, 2 weeks ago
Selected Answer: D
At first glance I thought it is a serverless. But serverless is General Purpose or Hyperscale. Both of them dont provide zero data loss. Therefore is D.
upvoted 1 times
...
profesorklaus
9 months, 2 weeks ago
Selected Answer: D
At first glance I thought it is a serverless. But serverless is General Purpose or Hyperscale. Both of them dont provide zero data loss. Therefore is D.
upvoted 2 times
vrm1358
1 week ago
100% correct. GP and Hyperscale only use failover (instead of always-on AG) that cannot offer zero-loss. It can only go as far as saving committed data.
upvoted 1 times
...
...
Lazylinux
1 year ago
Selected Answer: D
D meet the requirements
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago