Exam DP-300 topic 6 question 55 discussion

Actual exam question from Microsoft's DP-300

Question #: 55
Topic #: 6

SIMULATION
-

You need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region.

To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

Show Suggested Answer

Suggested Answer:

by pjfunner at June 7, 2024, 4:56 a.m.

Comments

Submit Cancel

2f5c7cd

8 months, 1 week ago

Should be using failover group to meet the ‘connection string myst he the same’ requirement

upvoted 1 times

voodoo_sh

6 months, 3 weeks ago

Agree. If you create geo-replica for individual SQL Databases (as answer describes), it will create a replica but you will have to change connection strings in an event of regional disaster. Need to configure failover group on Azure logical SQL Server level, which will create failover group's endpoints (read-write and read-only), in this case when failover occurs, connection strings will remain the same -> if you are using failover group's endpoints.

upvoted 1 times

...