Exam DP-300 topic 6 question 56 discussion

Actual exam question from Microsoft's DP-300

Question #: 56
Topic #: 6

SIMULATION
-

You need to configure high availability for db1. The solution must tolerate the loss of an Azure datacenter without data loss or the need to modify application connection strings.

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, 5:01 a.m.

Comments

Submit Cancel

itops_dba

7 months ago

I would change service tier to Business Critical, which provide HA https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla-local-zone-redundancy?view=azuresql&tabs=azure-powershell#premium-and-business-critical-service-tier-locally-redundant-availability

upvoted 1 times

voodoo_sh

6 months, 3 weeks ago

Agree. In Azure SQL Database, when you create a geo-replica or a standby replica, the replication is asynchronous. This means that transactions are committed on the primary database before they are replicated to the secondary database. As a result, there might be a slight delay in the data being replicated to the secondary, which can lead to potential data loss in the event of a failover. For Azure SQL Database failover groups, the replication between the primary and secondary databases is asynchronous. Because of above, I think provided answer is wrong. To tolerate loss of a data center without data loss, or the need to modify conn. strings -> go Business Critical or Premium, which should include zone-redundancy -> db resides in different zones and replication between zones is synchronous.

upvoted 1 times

...

st1a

10 months, 2 weeks ago

Sounds like you need a failover group created for the connectionstring part.

upvoted 1 times

...