Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 125 discussion

Actual exam question from Microsoft's AZ-305

Question #: 125
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 Standard
B. Azure SQL Managed Instance Business Critical
C. Azure SQL Database Serverless
D. Azure SQL Database Premium

Show Suggested Answer

Suggested Answer: D 🗳️

by Frank_2022 at March 8, 2024, 7 p.m.

Comments

Submit Cancel

Frank_2022

Highly Voted 1 year, 4 months ago

Selected Answer: D

The given answer is wrong. It should be D (Azure SQL Database Remium).

upvoted 5 times

HarryRhodes

1 year, 4 months ago

Agreed. Only choose Business Critical in the absence of Premium in these questions.

upvoted 5 times

kasper89

1 year ago

When to choose the Serverless pls?

upvoted 1 times

Gaz_

1 year ago

Premium > Serverless > Business Critical, in that order based on minimized costs

upvoted 3 times

...

K777121

Most Recent 3 months, 3 weeks ago

Selected Answer: B

The correct answer is: B. Azure SQL Managed Instance Business Critical Explanation: Failover with no data loss: The Business Critical tier uses Always On Availability Groups, ensuring that failover between replicas occurs without data loss. Zone outage resilience: It supports zone-redundant configurations, which ensure database availability even during a zone outage. Cost Efficiency: While it provides high availability, it is a cost-effective solution compared to other premium tiers for databases requiring these features.

upvoted 1 times

...

profesorklaus

11 months, 4 weeks ago

Selected Answer: D

At first glance I thought it is a serverless. But serverless is General Purpose or Hyperscale. Both of them dont provide zero data loss. Therefore is D.

upvoted 1 times

...

profesorklaus

11 months, 4 weeks ago

Selected Answer: D

At first glance I thought it is a serverless. But serverless is General Purpose or Hyperscale. Both of them dont provide zero data loss. Therefore is D.

upvoted 2 times

vrm1358

2 months, 2 weeks ago

100% correct. GP and Hyperscale only use failover (instead of always-on AG) that cannot offer zero-loss. It can only go as far as saving committed data.

upvoted 1 times

...

Lazylinux

1 year, 2 months ago

Selected Answer: D

D meet the requirements

upvoted 1 times

...