Exam AZ-305 topic 4 question 118 discussion

Actual exam question from Microsoft's AZ-305

Question #: 118
Topic #: 4

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 Managed Instance Business Critical
B. Azure SQL Database Business Critical
C. Azure SQL Database Basic
D. Azure SQL Database Standard

Show Suggested Answer

Suggested Answer: B 🗳️

by Crossfader2208 at March 7, 2024, 9:32 a.m.

Comments

Submit Cancel

Tharassiyil

8 months ago

This is repetition . In some cases I saw options for premium. Premium is cheaper than business critical ? can anyone clarify

upvoted 1 times

6c05b3d

6 months ago

Yes but this is not an option here. If there was a premium selection, you know that would be the right answer for this question.

upvoted 1 times

...

rumino

11 months, 4 weeks ago

Selected Answer: B

SQL Database Business Critical as it's cheaper than Managed Instance Business Critical

upvoted 2 times

...

Crossfader2208

12 months ago

How many copies of this question ET is going to post here. That is the question.