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

Actual exam question from Microsoft's AZ-305
Question #: 90
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 Hyperscale
  • B. Azure SQL Database Premium
  • C. Azure SQL Database Basic
  • D. Azure SQL Database Serverless
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by waqarahmed78 at April 19, 2023, 7:15 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
williamjcg
Highly Voted 5 months, 3 weeks ago
Hopefully this question will come up in my exam... I'll surely get it right
upvoted 6 times
...
c7d45f4
Most Recent 12 months ago
Selected Answer: B
Azure SQL Database Premium is correct
upvoted 2 times
...
joykdutta
1 year, 1 month ago
hiiiiiiiiiiiiiiiiii
upvoted 2 times
...
lombri
1 year, 2 months ago
Azure SQL Database Hyperscale is a scalable option for large workloads with flexible storage management. However, it is not specifically designed to ensure availability in case of zone outages and does not offer data-loss-free failover. Azure SQL Database Basic is the most cost-effective option but lacks advanced features such as automatic failover and high availability. Azure SQL Database Serverless is a cost-effective option for light and intermittent workloads but may not be suitable for an application requiring high availability without interruptions. Azure SQL Database Premium is the recommended option as it offers advanced features like active geo-replication and automatic, data-loss-free failover. It also supports high availability in case of zone outages, ensuring the database remains accessible even if a specific zone experiences an interruption
upvoted 2 times
Andy_S
1 year, 1 month ago
Answer C There is no mentioning about interruption. So correct Answer is "Serverless"
upvoted 3 times
...
...
techrat
1 year, 4 months ago
Selected Answer: B
Passed the exam with 979 today, my answer to this question on the exam was Premium
upvoted 3 times
...
waqarahmed78
1 year, 4 months ago
This Question is same as Question # 52 on page 31 and answer is different. Why? Shouldn't it be Serverless?
upvoted 4 times
yonie
1 year, 4 months ago
There are *16* variations of this question. Each of them offering different possible answers. The answer priority is as follows. If it exists then choose it. If it doesn't, proceeded to the next priority. Sometimes both appear in the same question, so make sure to select the higher priority. 1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical
upvoted 46 times
Paul_white
9 months, 1 week ago
This answer deserves more up votes
upvoted 3 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