MENU
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.
Suggested Answer: B, C
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
14 comments · newest first
BE
Ben
12 months ago
A is cool, but B is definitely the way to go!
LA
Lavonna
1 year ago
I agree with B, but I’m not sure about A.
CA
Carman
1 year ago
Wait, can you really avoid updating connection strings with just these options?
LE
Lennie
1 year ago
I think B is the right choice, but A seems unnecessary.
JA
Jacqueline
1 year ago
Definitely B and A for geo-replication!
TA
Tanesha
1 year ago
I don’t recall retention settings being relevant for this scenario. It feels like they wouldn’t help with connection issues during an outage.
AI
Ailene
1 year ago
I’m a bit confused about whether creating a new server is necessary. I thought failover groups would handle the regional outages better.
DO
Dominga
1 year ago
I remember practicing with failover groups in a similar question; it seems like a solid choice for ensuring connections without changing strings.
AN
Annamae
1 year ago
I think configuring geo-replication could help with failover, but I'm not entirely sure if it's the best option for seamless connection.
CE
Celestina
1 year ago
Okay, I think I've got a handle on this. Based on my understanding of Design Thinking, option B is probably the best approach. We shouldn't be too prescriptive with the interview guide and should let the team structure it themselves. That's more in line with the principles of the methodology.
DE
Devora
1 year ago
I'm a bit confused by the wording of the question. I'll need to re-read it a few times to make sure I understand exactly what the analyst is claiming and what the graphs are showing.
SE
Selma
1 year ago
I'm not really sure, but I feel like it might be A? It sounds familiar, like one of the practice questions we went over.
SH
Shantell
1 year ago
I'm a little confused by the wording of the options. I'll need to read through them slowly and make sure I'm interpreting them accurately before selecting my answer.
LO
Lorriane
1 year ago
Okay, let's see. We need to link the Rating entity to the Contact and Address information. I think creating the 1:N relationships between the entities is the way to go.