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?

AAzure SQL Database Premium

BAzure SQL Database Hyperscale

CAzure SQL Database Basic

DAzure SQL Managed Instance Business Critical

Show Suggested 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

Ashlyn

4 days 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

...

Johana

10 days 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

...

Clorinda

13 days 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

21 days ago

But wouldn't Azure SQL Managed Instance Business Critical be a better option for zone outage resilience?

upvoted 0 times

...

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

...

Cory

22 days ago

I agree with Izetta, Azure SQL Database Premium offers failover without data loss.

upvoted 0 times

...

Helga

24 days 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

1 months ago

I think we should go with Azure SQL Database Premium for high availability.

upvoted 0 times

...

Microsoft Exam AZ-305 Topic 10 Question 51 Discussion

Contribute your Thoughts:

Ashlyn

Johana

Clorinda

Edelmira

Carey

Cory

Helga

Izetta