DP-300 Certification Practice Question #180

Question

You have an instance of SQL Server on Azure Virtual Machines that has a database named DB1.
You plan to implement Azure SQL Data Sync for DB1.
Which isolation level should you configure?

Accepted Answer

When implementing SQL Data Sync, Microsoft specifies that snapshot isolation must be enabled for both the hub and all member databases. This is a mandatory requirement to guarantee that the synchronization engine can execute consistent reads without blocking or being blocked by concurrent user transactions. Therefore, SNAPSHOT (Option B) is the correct database isolation level to configure.

More DP-300 practice questions