Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 2 Question 125 Discussion

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure SQL database named Sales.You need to implement disaster recovery for Sales to meet the following requirements:During normal operations, provide at least two readable copies of Sales.Ensure that Sales remains available if a datacenter fails.Solution: You deploy an Azure SQL database that uses the General Purpose service tier and failover groups.Does this meet the goal?
B) No
A) Yes

Microsoft DP-300 Exam - Topic 2 Question 125 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 125
Topic #: 2
[All DP-300 Questions]

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an Azure SQL database named Sales.

You need to implement disaster recovery for Sales to meet the following requirements:

During normal operations, provide at least two readable copies of Sales.

Ensure that Sales remains available if a datacenter fails.

Solution: You deploy an Azure SQL database that uses the General Purpose service tier and failover groups.

Does this meet the goal?

Show Suggested Answer Hide Answer
Suggested Answer: B

Instead deploy an Azure SQL database that uses the Business Critical service tier and Availability Zones.

Note: Premium and Business Critical service tiers leverage the Premium availability model, which integrates compute resources (sqlservr.exe process) and storage (locally attached SSD) on a single node. High availability is achieved by replicating both compute and storage to additional nodes creating a three to four-node cluster.

By default, the cluster of nodes for the premium availability model is created in the same datacenter. With the introduction of Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated across multiple zones as three gateway rings (GW).


https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla

by Cherry at Mar 06, 2026, 12:54 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Gilbert
4 days ago
I agree with Alex. It’s a solid solution for disaster recovery.
upvoted 0 times
...
Katina
9 days ago
Failover groups ensure availability. So, yes!
upvoted 0 times
...
Nada
14 days ago
I’m not sure. What if the datacenter fails?
upvoted 0 times
...
Jani
20 days ago
I think it meets the goal. Two readable copies are covered.
upvoted 0 times
...
Dylan
25 days ago
I feel confident with A) Yes. It meets all requirements.
upvoted 0 times
...
Edmond
30 days ago
I'm not so sure. What if the service tier isn't enough?
upvoted 0 times
...
Virgie
1 month ago
I agree, A) Yes. Failover groups ensure availability.
upvoted 0 times
...
Nadine
1 month ago
I think the answer is A) Yes. It provides readable copies.
upvoted 0 times
...
Veronika
2 months ago
I feel confident with A) Yes. It meets the requirements for disaster recovery.
upvoted 0 times
...
Hubert
2 months ago
I'm not so sure. I lean towards B) No. What if the service tier isn't sufficient?
upvoted 0 times
...
Gianna
2 months ago
I agree, A) Yes. It provides high availability and readable replicas.
upvoted 0 times
...
Shannon
2 months ago
I think the answer is A) Yes. Failover groups are designed for this.
upvoted 0 times
...
Venita
2 months ago
Totally surprised by how easy Azure makes this!
upvoted 0 times
...
Brunilda
2 months ago
Wait, are we sure about the General Purpose tier?
upvoted 0 times
...
Bettyann
4 months ago
Failover groups are a solid choice for high availability!
upvoted 0 times
...
Filiberto
4 months ago
I think it might not be enough for full disaster recovery.
upvoted 0 times
...
Shenika
4 months ago
Yes, that definitely meets the goal!
upvoted 0 times
...
Lorita
4 months ago
Wait, can it really handle a datacenter failure?
upvoted 0 times
...
Valentin
5 months ago
Definitely a good approach!
upvoted 0 times
...
Tamekia
5 months ago
Not sure about the General Purpose tier for failover.
upvoted 0 times
...
Yolando
5 months ago
I think it meets the requirements.
upvoted 0 times
...
Delpha
5 months ago
Yes, that sounds right!
upvoted 0 times
...
Tiara
5 months ago
I think this setup could work, but I vaguely recall that there might be limitations with the General Purpose tier regarding disaster recovery options.
upvoted 0 times
...
Cheryl
5 months ago
I believe failover groups can provide the necessary redundancy, but I’m a bit uncertain if the General Purpose tier can handle the load during a datacenter failure.
upvoted 0 times
...
Berry
6 months ago
I remember practicing a similar question where we had to ensure readable secondaries. I feel like this solution might not fully meet that requirement.
upvoted 0 times
...
Charlesetta
6 months ago
I think using failover groups is a good approach for high availability, but I'm not sure if the General Purpose tier supports all the features we need.
upvoted 0 times
...

Save Cancel