Microsoft DP-300 Exam - Topic 8 Question 50 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 50
Topic #: 8

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.

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.

Show Suggested 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:

Submit Cancel

Ben

4 months ago

A is cool, but B is definitely the way to go!

upvoted 0 times

...

Lavonna

4 months ago

I agree with B, but I’m not sure about A.

upvoted 0 times

...

Carman

4 months ago

Wait, can you really avoid updating connection strings with just these options?

upvoted 0 times

...

Lennie

5 months ago

I think B is the right choice, but A seems unnecessary.

upvoted 0 times

...

Jacqueline

5 months ago

Definitely B and A for geo-replication!

upvoted 0 times

...

Tanesha

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

...