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?

The correct answer is B. SNAPSHOT. https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-

Submitted by krish.m· Mar 6, 2026Plan and implement data platform resources

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?

Options

ASERIALIZABLE
BSNAPSHOT
CREAD UNCOMMITTED
DREAD COMMITTED

How the community answered

(18 responses)

A
6% (1)
B
72% (13)
C
6% (1)
D
17% (3)

Explanation

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-

Topics

#Azure SQL Data Sync#isolation level#SNAPSHOT isolation#SQL Server on Azure VMs

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice