DP-300 Certification Practice Question #212

Question

You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements:
✑ Support failovers that do not require client applications to change their connection strings.
✑ Replicate the database to a secondary Azure region.
✑ Support failover to the secondary region.
What should you include in the recommendation?

Accepted Answer

To support failover to a secondary Azure region without requiring client applications to modify their connection strings, failover groups (option A) must be used. Failover groups provide read-write and read-only listener endpoints (`<fog-name>.database.windows.net`) that automatically redirect client connections to the active primary replica. If a failover to the secondary region occurs, the DNS record updates transparently, routing traffic to the new region without connection string updates. While active geo-replication (option D) supports geo-redundancy, it lacks these unified endpoints, necessitating manual client-side connection modifications during failovers.

More DP-300 practice questions