DP-300 Certification Practice Question #286

Question

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

Accepted Answer

The PaaS disaster recovery requirement is automatic failover during an Azure regional outage. Auto-failover groups are the only option among the four that: (1) are available for Azure SQL Database PaaS, (2) support automatic failover, and (3) provide stable DNS listener endpoints so connection strings do not need updating after a failover. Geo-replication (D) is eliminated because it requires manual failover. Availability Zones (A) protect against datacenter-level failures within a region, not regional outages. Always On AG (C) is an IaaS SQL Server feature. All community votes and the Suggested Answer agree on B.

More DP-300 practice questions