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 3 question 14 discussion

Actual exam question from Microsoft's AZ-305
Question #: 14
Topic #: 3
[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 Premium
  • C. Azure SQL Database Basic
  • D. Azure SQL Database Hyperscale
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Snownoodles at Sept. 5, 2022, 5:49 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
Snownoodles
Highly Voted 2 years, 7 months ago
duplicate with Quesion 13. The given answer is correct
upvoted 13 times
Elton_Bicalho
2 years, 7 months ago
It is not duplicated. The answer options are different(trick). Pay attention to the COST.
upvoted 5 times
mdmahanti
2 years, 6 months ago
Even the COST aspect is duplicated.
upvoted 4 times
Dudulle
2 years, 5 months ago
Yep, entirely same question and entirely different answer. Indeed, B is the correct one (for both, obviously). Would suggest this site to fix this ...
upvoted 2 times
...
...
...
...
dubuser
Highly Voted 2 years, 2 months ago
Appeared in todays exam (29/01/23) But Premium was not in choices had Business Critical instead for Azure SQL and Azure MI I answered Azure MI Business Critical assuming Failover meant Auto-Failover groups Scored 903
upvoted 8 times
EXzw
2 years, 1 month ago
I think should choose Business Critical for Azure SQL, the cheapest Azure SQL BC less than 1K USD for 2vCore less than 2K USD for 4vCore and for MI BC 4vCore Cost about 2.1K USD (please correct me if i'm wrong)
upvoted 2 times
...
...
Giovanotto
Most Recent 1 year, 1 month ago
Selected Answer: C
You can activate geo-replication on another zone even with basic tier. So I guess is basic. Maybe in the post was different
upvoted 1 times
RV3472
7 months, 4 weeks ago
Geo-replication uses asynchronous sync so there might be data loss.
upvoted 2 times
...
...
JoShizo
1 year, 1 month ago
Selected Answer: B
Duplicate question but this time the suggested answer is correct. B.
upvoted 1 times
...
kingfighers
1 year, 2 months ago
why some ppl say this question is duplicated with question 13?? question 13 correct solution is D: Azure SQL Managed Instance General Purpose, which is not existed in this question 14.
upvoted 2 times
...
ArunS005
1 year, 6 months ago
Selected Answer: B
Duplicate to previous question. The answer is "Azure SQL Database Premium".
upvoted 1 times
...
theboywonder
1 year, 10 months ago
duplicate, B is correct fo sho
upvoted 1 times
...
jj22222
2 years, 1 month ago
this is duplicate with right answer
upvoted 1 times
...
zellck
2 years, 2 months ago
Same as Question 16. https://www.examtopics.com/discussions/microsoft/view/79423-exam-az-305-topic-2-question-16-discussion
upvoted 1 times
...
zellck
2 years, 2 months ago
Selected Answer: B
B is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql#service-tiers The Premium service tier is designed for OLTP applications with high transaction rates and low latency I/O requirements. It offers the highest resilience to failures by using several isolated replicas.
upvoted 1 times
...
VBK8579
2 years, 2 months ago
Selected Answer: B
The best option would be to use Azure SQL Database Premium as it provides failover between replicas of the database with no data loss and also supports zone redundancy to ensure availability in the event of a zone outage. Additionally, Azure SQL Database Premium is more cost-effective compared to the higher-tier options such as Azure SQL Managed Instance Business Critical. If Premium isn't given option in exam then A
upvoted 3 times
...
OPT_001122
2 years, 3 months ago
Selected Answer: B
B. Azure SQL Database Premium
upvoted 1 times
...
Gowind2
2 years, 7 months ago
Selected Answer: B
https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell Zone-redundant configuration is not available in SQL Managed Instance. In SQL Database this feature is only available when the Gen5 hardware is selected. To prevent Data Loss, Premium/Business Critical is required: The primary node constantly pushes changes to the secondary nodes in order and ensures that the data is persisted to at least one secondary replica before committing each transaction. This process guarantees that if the primary node crashes for any reason, there is always a fully synchronized node to fail over to
upvoted 2 times
...
Joalmici
2 years, 7 months ago
Selected Answer: B
The B is the correct.
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