DP-300 Question #459: Real Exam Question with Answer & Explanation

Question

You have an Azure subscription that contains an Azure SQL database named DB1. You need to recommend a high availability, disaster recovery (HA/DR) solution for DB1. The solution must meet the following requirements: - Ensure that a recovery time objective (RTO) of less than five minutes can be met. - Ensure that a recovery point objective (RPO) of less than 30 seconds can be met. - Ensure availability in the event of an Azure region outage. What should you include in the recommendation?

Options

• Azone redundancy
• Bfailover groups
• Cgeo-restore
• DAzure Site Recovery

Explanation

To protect an Azure SQL Database from a regional outage, you should implement disaster recovery solutions like active geo-replication or failover groups to create a secondary, readable replica in a different Azure region. Azure failover groups for Azure SQL Database offer a Recovery Time Objective (RTO) of typically less than 60 seconds and a Recovery Point Objective (RPO) of 5 seconds. This means that, in the event of a failover, your database should be back online within a minute, and you might experience a maximum of 5 seconds of data loss. Active Geo-Replication and Failover Groups: Active Geo-Replication: This feature allows you to create readable secondary databases in different Azure regions. It provides a mechanism for failover to the secondary database in case of a regional outage, minimizing downtime. Failover Groups: Failover groups simplify the management of geo-replicated databases, enabling automatic failover of multiple databases simultaneously. They also provide read-write and read-only listener endpoints that remain unchanged after failover, simplifying application updates. https://learn.microsoft.com/en-us/azure/azure-sql/database/failover-group-sql-db?view=azuresql

No community discussion yet for this question.