ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam
Go to Exam

Exam AZ-305 topic 4 question 94 discussion

Actual exam question from Microsoft's AZ-305
Question #: 94
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 Managed Instance General Purpose
  • C. Azure SQL Database Standard
  • D. Azure SQL Database Premium
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by acepanda99 at Aug. 23, 2023, 11:48 p.m.

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
Submit Cancel
OrangeSG
Highly Voted 1 year, 9 months ago
Selected Answer: D
This question appears a lot of time, with different options as answer. Always the answers are (in this order): 1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical If there is only one of them, select it. If there are 2 of them, remember the order, and select the option in the order showed here.
upvoted 17 times
...
Thanveer
Most Recent 9 months, 1 week ago
For high availability/no data loss related question, the answer is either Business Critical ( for vcore based) or Premium ( for DTU based)
upvoted 1 times
...
joesatriani
1 year, 10 months ago
Selected Answer: D
This is another duplicate question.
upvoted 1 times
...
c7d45f4
1 year, 11 months ago
Selected Answer: D
Now its D,Azure SQL Database Premium
upvoted 1 times
...
RouterWifi443
1 year, 11 months ago
Selected Answer: D
Duplicated
upvoted 1 times
...
acepanda99
1 year, 12 months ago
Duplicated Question
upvoted 1 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