Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 3 question 14 discussion

Actual exam question from Microsoft's AZ-305

Question #: 14
Topic #: 3

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

Suggested Answer: B 🗳️

by Snownoodles at Sept. 5, 2022, 5:49 p.m.

Comments

Submit Cancel

Snownoodles

Highly Voted 2 years, 10 months ago

duplicate with Quesion 13. The given answer is correct

upvoted 13 times

Elton_Bicalho

2 years, 9 months ago

It is not duplicated. The answer options are different(trick). Pay attention to the COST.

upvoted 5 times

mdmahanti

2 years, 8 months ago

Even the COST aspect is duplicated.

upvoted 4 times

Dudulle

2 years, 7 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, 5 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, 3 months 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, 3 months 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

10 months ago

Geo-replication uses asynchronous sync so there might be data loss.

upvoted 2 times

...

JoShizo

1 year, 4 months ago

Selected Answer: B

Duplicate question but this time the suggested answer is correct. B.

upvoted 1 times

...

kingfighers

1 year, 4 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, 8 months ago

Selected Answer: B

Duplicate to previous question. The answer is "Azure SQL Database Premium".

upvoted 1 times

...

theboywonder

2 years ago

duplicate, B is correct fo sho

upvoted 1 times

...

jj22222

2 years, 4 months ago

this is duplicate with right answer

upvoted 1 times

...

zellck

2 years, 4 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, 4 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, 5 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, 5 months ago

Selected Answer: B

B. Azure SQL Database Premium

upvoted 1 times

...

Gowind2

2 years, 9 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, 9 months ago

Selected Answer: B

The B is the correct.

upvoted 3 times

...