Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 8 Question 50 Discussion

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.
B) From the properties of Server1 add a failover group. and C) Create a new Azure SQL Database server named Server2.
A) From the properties of DB1. configure geo-replication.
D) From the properties of Server1 configure retention for DB1
E) Create a new Azure SQL Database instance named DB2.

Microsoft DP-300 Exam - Topic 8 Question 50 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 50
Topic #: 8
[All DP-300 Questions]

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.

Show Suggested Answer Hide Answer
Suggested Answer: B, C

https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell#best-practices-for-sql-database

https://docs.microsoft.com/en-us/azure/azure-sql/database/failover-group-add-single-database-tutorial?tabs=azure-portal

by Noah at May 07, 2022, 09:17 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Ben
10 months ago
A is cool, but B is definitely the way to go!
upvoted 0 times
...
Lavonna
10 months ago
I agree with B, but I’m not sure about A.
upvoted 0 times
...
Carman
11 months ago
Wait, can you really avoid updating connection strings with just these options?
upvoted 0 times
...
Lennie
11 months ago
I think B is the right choice, but A seems unnecessary.
upvoted 0 times
...
Jacqueline
11 months ago
Definitely B and A for geo-replication!
upvoted 0 times
...
Tanesha
11 months 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.
upvoted 0 times
...
Ailene
11 months ago
I’m a bit confused about whether creating a new server is necessary. I thought failover groups would handle the regional outages better.
upvoted 0 times
...
Dominga
11 months ago
I remember practicing with failover groups in a similar question; it seems like a solid choice for ensuring connections without changing strings.
upvoted 0 times
...
Annamae
11 months 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.
upvoted 0 times
...
Celestina
11 months 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.
upvoted 0 times
...
Devora
11 months 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.
upvoted 0 times
...
Selma
11 months 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.
upvoted 0 times
...
Shantell
11 months 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.
upvoted 0 times
...
Lorriane
11 months 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.
upvoted 0 times
...

Save Cancel