DP-300 Certification Practice Question #227

Question

You have a new Azure subscription.
You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1.
You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage, applications that connect to DB1 must be able to connect without having to update the connection strings.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Accepted Answer

To allow database connections to transparently fail over to another region during an outage without updating client connection strings, an Azure SQL Auto-failover group must be used. Creating a failover group requires a partner logical server in the target region. Therefore, you must first create a new Azure SQL Database server named Server2 (Option C) in the secondary region. Then, from the primary server (Server1), you configure the Auto-failover group (Option B), listing Server2 as the secondary partner server and adding DB1 to the group. This sets up the DNS listener endpoints that allow applications to connect without modifying connection strings.

More DP-300 practice questions