DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ10

Monitor, configure, and optimize database resources

You have a SQL Server instance running on Azure Virtual Machines that contains a database named DB1.

You plan to implement Azure SQL Data Sync for DB1.

Which isolation level should you configure?

Explanation

Azure SQL Data Sync requires snapshot isolation to be enabled on both the sync hub and all sync members. SQL Server enables use of this level through the ALLOW_SNAPSHOT_ISOLATION database option.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!