Microsoft Discussions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Go to Exam

Exam AZ-305 topic 4 question 118 discussion

Actual exam question from Microsoft's AZ-305

Question #: 118
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 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

1 year, 1 month ago

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

upvoted 2 times

6c05b3d

11 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 2 times

...

...

rumino

1 year, 4 months ago

Selected Answer: B

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

upvoted 2 times

...

Crossfader2208

1 year, 4 months ago

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

upvoted 2 times

...