Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 3 question 16 discussion

Actual exam question from Microsoft's AZ-305

Question #: 16
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 Database Serverless
B. Azure SQL Database Business Critical
C. Azure SQL Database Basic
D. Azure SQL Database Standard

Show Suggested Answer

Suggested Answer: B 🗳️

by shubhary25 at Sept. 1, 2022, 1:05 p.m.

Comments

Submit Cancel

marcelina50

Highly Voted 2 years, 1 month ago

Selected Answer: B

Where are you mlantonis

upvoted 131 times

Sr18

11 months, 2 weeks ago

Its BC for sure

upvoted 1 times

...

Snownoodles

Highly Voted 2 years, 9 months ago

Both AZ sql database standard and serverless(both are general purpose) support zone redundancy. It's hard to compare cost between AZ database standard and AZ database serverless without a usage patterns. In general, we can say Az database serverless is cost-effective. So the given answer might be correct.

upvoted 30 times

vrm1358

2 months, 3 weeks ago

AZ sql standard DOES NOT SUPPORT zone redundancy: Zone-redundant availability is available to databases in the Business Critical, General Purpose and Hyperscale service tiers of the vCore-based purchasing model, and only the Premium service tier of the DTU-based purchasing model - the Basic and Standard service tiers don't support zone redundancy. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla-local-zone-redundancy?view=azuresql&tabs=azure-powershell

upvoted 1 times

...

zellck

2 years, 3 months ago

Azure SQL DB Standard tier only supports LRS. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#basic-standard-and-general-purpose-service-tier-locally-redundant-availability

upvoted 3 times

...

leoletopic

2 years, 6 months ago

"Auto-failover groups support geo-replication of all databases in the group to only one secondary server in a different region" ,So ,if you need only one secondary server to support failover, you must use Geo-Redundancy. not Zone Redundancy. If you want in same regions ,you need more servers,which is not min cost https://learn.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-sql-db?view=azuresql&tabs=azure-powershell

upvoted 1 times

...

sunis1

1 year, 8 months ago

While Azure SQL Database Serverless does offer cost savings, it may not meet your specific requirements for a few reasons: Data Loss: Azure SQL Database Serverless does not guarantee that committed data is never lost due to failures. This could potentially lead to data loss during failover, which does not align with your requirement for failover between replicas of the database to occur without any data loss. Availability during Zone Outages: While Azure SQL Database Serverless does provide automatic scaling and pausing/resuming of databases, it does not specifically guarantee availability in the event of a zone outage1.

upvoted 2 times

...

abrakadabra200

Most Recent 1 month, 1 week ago

Selected Answer: A

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

upvoted 4 times

...

Ekramy_Elnaggar

2 months, 4 weeks ago

Selected Answer: B

Answer is Correct Serverless and Standard: Offer high availability but typically rely on standard availability (within a single availability zone) and might have potential data loss during a zone-level failure.

upvoted 1 times

...

_fvt

4 months, 2 weeks ago

Selected Answer: C

DTU model (Basic and Standard dosen't explicitely have Zone Redundancy options but a 99.99% SLA which implies it), and vCore Business Critical does. I will go with C.

upvoted 1 times

...

07d6037

5 months ago

Selected Answer: A

Serverless > B. Critical

upvoted 1 times

...

KapitanPletwal

6 months, 3 weeks ago

Selected Answer: A

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

upvoted 9 times

...

Thanveer

6 months, 4 weeks ago

Selected Answer: A

A is correct

upvoted 2 times

...

[Removed]

7 months, 1 week ago

Selected Answer: A

A is correct This Question has 3 answers based on the priority: 1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical

upvoted 3 times

...

[Removed]

7 months, 2 weeks ago

Selected Answer: B

B is correct

upvoted 1 times

[Removed]

7 months, 1 week ago

after researches, A is correct as per priority it must be: 1. Azure SQL Database Premium 2. Azure SQL Database Serverless 3. Azure SQL Database Business Critical

upvoted 1 times

...

CompetentNinja

8 months, 2 weeks ago

Selected Answer: A

Order to choose is Premium, Serverless, Business Critical

upvoted 3 times

...

Lazylinux

1 year, 2 months ago

Selected Answer: B

B is Honey availability = Three replicas, one read-scale replica, zone-redundant high availability (HA)

upvoted 2 times

...

LGWJ12

1 year, 2 months ago

Selected Answer: B

Azure SQL Database Business Critical is cheaper.

upvoted 3 times

...

hanoki6540

1 year, 3 months ago

its either A or B also serverless is a compute tier not performance tier both general purpose or hyperscale supports surverless deployments.

upvoted 1 times

...

WeepingMaplte

1 year, 4 months ago

Selected Answer: B

Zone-redundant availability is available to databases in the General Purpose, Premium, Business Critical and Hyperscale service tiers of the vCore purchasing model, and not the Basic and Standard service tiers of the DTU-based purchasing model. Zone-redundant availability ensures Recovery Point Objective (RPO) which indicates the amount of data loss is zero. Taken from: https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#:~:text=ensures%20Recovery%20Point%20Objective%20(RPO)%20which%20indicates%20the%20amount-,of%20data%20loss,-is%20zero.

upvoted 4 times

profesorklaus

1 year, 1 month ago

Zone-Redundand is available in General Purpose Serverless. General Purpose is in Locally redundant availability model. Locally redundant availability is available to all databases in all service tiers and Recovery Point Objective (RPO) which indicates the amount of data loss is zero. So you are wrong.

upvoted 1 times

...

[Removed]

1 year, 5 months ago

Selected Answer: A

Premium -> Serverless -> BC, that's the preferred order.

upvoted 14 times

...

ziggy1117

1 year, 6 months ago

Selected Answer: A

Zone-redundant configuration for the General Purpose service tier is offered for both serverless and provisioned compute for databases in vCore purchasing model. Serverless is assumed to be cheaper https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell

upvoted 4 times

profesorklaus

1 year, 1 month ago

Agree. I checked in Azure Price Calculator. It seems event obvious to be cheaper by serveless as it requires less resources to be engaged

upvoted 1 times

...

Rouix

1 year, 2 months ago

Agree. Go here with Serverless option. Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose#regions-supporting-80-maximum-vcores-with-availability-zones-for-general-purpose

upvoted 1 times

...

Load full discussion...