Microsoft DP-300 Exam - Topic 9 Question 27 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 27
Topic #: 9

[All DP-300 Questions]

What should you implement to meet the disaster recovery requirements for the PaaS solution?

AAvailability Zones

Bfailover groups

CAlways On availability groups

Dgeo-replication

Show Suggested Answer

Suggested Answer: B

Scenario: In the event of an Azure regional outage, ensure that the customers can access the PaaS solution with minimal downtime. The solution must provide automatic failover.

The auto-failover groups feature allows you to manage the replication and failover of a group of databases on a server or all databases in a managed instance to another region. It is a declarative abstraction on top of the existing active geo-replication feature, designed to simplify deployment and management of geo-replicated databases at scale. You can initiate failover manually or you can delegate it to the Azure service based on a user-defined policy.

The latter option allows you to automatically recover multiple related databases in a secondary region after a catastrophic failure or other unplanned event that results in full or partial loss of the SQL Database or SQL Managed Instance availability in the primary region.

https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview

by Yuki at May 06, 2022, 02:27 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Mozell

9 months ago

Wait, can you really rely on just one of these options?

upvoted 0 times

...

Domitila

9 months ago

Geo-replication is a must for global apps!

upvoted 0 times

...

Louisa

9 months ago

Always On availability groups seem like overkill for some setups.

upvoted 0 times

...

Lavonna

9 months ago

Totally agree, failover groups are essential too!

upvoted 0 times

...

Pamella

9 months ago

Availability Zones are key for redundancy.

upvoted 0 times

...

Carin

9 months ago

Always On availability groups seem like a solid choice, but I need to double-check if they apply to PaaS environments.

upvoted 0 times

...

Jaime

10 months ago

I think failover groups might be relevant here, especially since we practiced a similar question last week.

upvoted 0 times

...

Junita

10 months ago

I remember studying about availability zones, but I'm not sure if they are the best option for PaaS disaster recovery.

upvoted 0 times

...

Audry

10 months ago

Geo-replication sounds familiar, but I can't recall if it's specifically for PaaS solutions or more for IaaS.

upvoted 0 times

...

Coletta

10 months ago

Hmm, this seems like a tricky one. I'll need to think through the project lifecycle stages carefully to figure out the right document.

upvoted 0 times

...

Antonio

10 months ago

I think the first step might involve creating groups of interest; it makes sense to define what to work with first.

upvoted 0 times

...

Luisa

10 months ago

Okay, I've got a strategy here. I'll focus on how the level of aggregation could affect the visibility of demand and resource imbalances. That seems like the core issue they're getting at.

upvoted 0 times

...