Microsoft
DP-300 · Question #193
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 a
Sign in or unlock DP-300 to reveal the answer and full explanation for question #193. The question stem and answer options stay visible for context.
Submitted by salim_om· Mar 6, 2026Plan and implement a HADR environment
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.
Exhibit
Options
- AFrom the properties of DB1. configure geo-replication.
- BFrom the properties of Server1 add a failover group.
- CCreate a new Azure SQL Database server named Server2.
- DFrom the properties of Server1 configure retention for DB1
- ECreate a new Azure SQL Database instance named DB2.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#failover groups#geo-replication#regional outage#connection string transparency