exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 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 Hide Answer
Suggested Answer: B 🗳️

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
Tharassiyil
5 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
3 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
9 months ago
Selected Answer: B
SQL Database Business Critical as it's cheaper than Managed Instance Business Critical
upvoted 2 times
...
Crossfader2208
9 months ago
How many copies of this question ET is going to post here. That is the question.
upvoted 2 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
Loading ...