DP-300 Certification Practice Question #220

Question

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?

Accepted Answer

The proposed solution does not meet the goal. While a failover group in the General Purpose service tier provides one geo-secondary readable replica (resulting in two readable copies during normal operations), it fails the availability requirement in the event of a datacenter outage. Automatic failover for failover groups has a minimum grace period of one hour before it can be triggered, resulting in substantial downtime. A seamless failover within the region during a datacenter failure requires the Business Critical or Premium tier with zone redundancy enabled.

More DP-300 practice questions