Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft Exam AZ-305 Topic 10 Question 51 Discussion

Actual exam question for Microsoft's AZ-305 exam
Question #: 51
Topic #: 10
[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?

Show Suggested Answer Hide Answer
Suggested Answer: D, E

by Christiane at Mar 09, 2024, 02:21 PM

Limited Time Offer

25%

Off

Get Premium AZ-305 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Novella
4 months ago
I wonder if the Azure SQL Database 'Hyperbole' tier promises 99.999999999% availability and can withstand a direct hit from a nuclear warhead. Sign me up!
upvoted 0 times
Roselle
3 months ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Robt
3 months ago
C) Azure SQL Database Basic
upvoted 0 times
...
Reena
3 months ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Della
4 months ago
A) Azure SQL Database Premium
upvoted 0 times
...
...
Ashlyn
5 months ago
Wait, there's an 'Azure SQL Database Meme-scale' tier? I hear that one comes with built-in dad jokes and a guarantee of at least one Monty Python reference per query.
upvoted 0 times
Twana
3 months ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Edward
3 months ago
C) Azure SQL Database Basic
upvoted 0 times
...
Kami
4 months ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Ty
4 months ago
A) Azure SQL Database Premium
upvoted 0 times
...
...
Johana
5 months ago
I'm not sure, but I heard that Azure SQL Database Basic is the most affordable option. Maybe it's worth considering if they're really looking to minimize costs.
upvoted 0 times
Coleen
3 months ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Kallie
3 months ago
C) Azure SQL Database Basic
upvoted 0 times
...
Tegan
3 months ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Kenneth
4 months ago
A) Azure SQL Database Premium
upvoted 0 times
...
...
Clorinda
5 months ago
This is a tough one, but I think Azure SQL Database Premium is the way to go. The premium tier ensures zero data loss during failover, which is critical for this use case.
upvoted 0 times
...
Edelmira
5 months ago
But wouldn't Azure SQL Managed Instance Business Critical be a better option for zone outage resilience?
upvoted 0 times
...
Carey
5 months ago
I'm leaning towards Azure SQL Managed Instance Business Critical. The business-critical tier provides the necessary failover and availability features, and it might be a more cost-effective solution than the premium tier.
upvoted 0 times
Bernadine
3 months ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Paris
4 months ago
I agree, Azure SQL Managed Instance Business Critical seems like the best option for meeting all the requirements while keeping costs low.
upvoted 0 times
...
Cary
4 months ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Hailey
4 months ago
C) Azure SQL Database Basic
upvoted 0 times
...
Jillian
4 months ago
C) Azure SQL Database Basic
upvoted 0 times
...
Alverta
4 months ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Adrianna
4 months ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Jamal
4 months ago
A) Azure SQL Database Premium
upvoted 0 times
...
Ernie
4 months ago
A) Azure SQL Database Premium
upvoted 0 times
...
...
Cory
5 months ago
I agree with Izetta, Azure SQL Database Premium offers failover without data loss.
upvoted 0 times
...
Helga
5 months ago
Azure SQL Database Hyperscale seems like the perfect choice here. It offers high availability, zone-redundancy, and cost-optimization - exactly what the requirements call for.
upvoted 0 times
...
Izetta
5 months ago
I think we should go with Azure SQL Database Premium for high availability.
upvoted 0 times
...

Save Cancel