Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 99 discussion

Actual exam question from Microsoft's AZ-305

Question #: 99
Topic #: 4

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 Serverless
B. Azure SQL Managed Instance General Purpose
C. Azure SQL Database Basic
D. Azure SQL Database Business Critical

Show Suggested Answer

Suggested Answer: A 🗳️

by gca22 at April 23, 2023, 3:21 a.m.

Comments

Submit Cancel

yonie

Highly Voted 2 years, 1 month 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 137 times

hotspot02103

1 month, 1 week ago

give me btc address, wanna send u some, my hero

upvoted 1 times

...

HarryRhodes

1 year, 2 months ago

Good stuff yonie, you beat me to it.

upvoted 1 times

...

betterthanlife

2 years, 1 month ago

It is true, thanks yonie.

upvoted 4 times

...

SandCloud

2 years, 1 month ago

thanks yonie

upvoted 5 times

...

Azwscp2023

Highly Voted 1 year, 7 months ago

Selected Answer: D

D. Azure SQL Database Business Critical Azure SQL Database Serverless is a good option for workloads that experience variable or unpredictable traffic. However, it does not offer the same level of high availability as Azure SQL Database Business Critical.

upvoted 6 times

pra_nj

3 months, 1 week ago

D. Azure SQL Database Business Critical Here's why: Failover Without Data Loss: The Business Critical tier uses synchronous replication, ensuring that failover between replicas occurs without any data loss. Zone Outage Resilience: It supports zone redundancy, ensuring that the database remains available even in the event of a zone outage. Cost Efficiency: While providing high availability and resilience, it is generally more cost-effective compared to other options that offer similar levels of availability and data integrity. This option balances high availability, data integrity, and cost efficiency, making it the most suitable choice for your requirements.

upvoted 2 times

...

SardarAbdulBasit

Most Recent 1 week, 3 days ago

Selected Answer: D

Answer is D

upvoted 1 times

...

abrakadabra200

1 month ago

Selected Answer: A

1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical

upvoted 1 times

...

khaled_razouk

1 month, 2 weeks ago

Selected Answer: D

Azure SQL Database Business Critical

upvoted 1 times

...

7f3f6bd

4 months, 1 week ago

Selected Answer: D

Business Critical is more expensive than Basic or General Purpose but is the cheapest option that meets all HA requirements.

upvoted 2 times

...

[Removed]

7 months ago

Selected Answer: A

A is correct

upvoted 1 times

...

ArtCr

7 months ago

Selected Answer: A

Lower cost

upvoted 2 times

...

_punky_

7 months, 3 weeks ago

Selected Answer: A

Serveless

upvoted 2 times

...

620b351

7 months, 3 weeks ago

Selected Answer: D

Just called Mlantonis, it's D.

upvoted 2 times

...

84e067a

7 months, 3 weeks ago

Selected Answer: D

D: Azure SQL Database Business Critical

upvoted 1 times

...

Teerawee

9 months ago

Selected Answer: D

Azure SQL Database Business Critical

upvoted 1 times

...

e5469b9

9 months, 2 weeks ago

Selected Answer: A

Premium - Serverless - Critical, in that order

upvoted 4 times

...

OlehT

11 months, 1 week ago

Selected Answer: D

It should be D, Serverless is an vCore-based Purchasing Model Plan. For ensuring failover without data loss and maintaining availability during zone outages go: Azure SQL Managed Instance Business Critical. Serverless is designed for cost savings and is more suited for workloads with intermittent, unpredictable usage patterns.

upvoted 2 times

OlehT

11 months, 1 week ago

Azure SQL Database Business Critical*

upvoted 1 times

...

CharlesS76

11 months, 3 weeks ago

Selected Answer: A

Cost Of : Premium < Serverless < Business Critical < HyperScale

upvoted 3 times

...

Lazylinux

1 year, 1 month ago

Selected Answer: D

I would go for D but im as confused as hell and honestly when we do this in real life we have all resources from People, online doc etc and even discuss with MS... this is the ONLY question i see answers split 50% for A and 50% for D...Now i conclude that Microsoft is truly a lame duck :)...

upvoted 1 times

...

dejedi

1 year, 2 months ago

Selected Answer: A

I would go for this serie of question with this priority order Premium , serverless , business Critical In this case Serverless

upvoted 2 times

...

Load full discussion...