Discuss Microsoft DP-300 Exam Topic 9 Question 27

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

AAvailability Zones

Bfailover groups

CAlways On availability groups

Dgeo-replication

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

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

12 comments · newest first

Mozell 12 months ago

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

Domitila 1 year ago

Geo-replication is a must for global apps!

Louisa 1 year ago

Always On availability groups seem like overkill for some setups.

Lavonna 1 year ago

Totally agree, failover groups are essential too!

Pamella 1 year ago

Availability Zones are key for redundancy.

Carin 1 year ago

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

Jaime 1 year ago

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

Junita 1 year ago

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

Audry 1 year ago

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

Coletta 1 year 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.

Antonio 1 year ago

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

Luisa 1 year 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.

Microsoft DP-300 Exam - Topic 9 Question 27 Discussion