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 95 discussion

Actual exam question from Microsoft's AZ-305
Question #: 95
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 Database Business Critical
  • B. Azure SQL Database Basic
  • C. Azure SQL Managed Instance General Purpose
  • D. Azure SQL Database Hyperscale
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by csol at April 27, 2023, 1:14 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 4 months ago
Selected Answer: A
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 13 times
...
Tplenty
Most Recent 3 months, 3 weeks ago
This question better come out in the exam because it's repeated multiple times
upvoted 2 times
...
c7d45f4
5 months, 3 weeks ago
Selected Answer: A
Azure SQL Database Business Critical is the one
upvoted 1 times
...
joesatriani
8 months ago
Selected Answer: A
Answer is A, I just tested also check this table this took me to the answer https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-general-purpose-business-critical#service-tier-comparison fast failover only applies for biz critical and only azure sql support and Would you like to make this database zone redundant? is only available for normal Azure SQL and not for managed instances.
upvoted 2 times
...
csol
10 months, 1 week ago
Selected Answer: A
A - Hyperscale is more expensive and the other options doesn´t support zone outage
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago