MENU
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?
Suggested Answer: B
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
11 comments · newest first
MA
Matilda
12 months ago
Wait, are we sure SNAPSHOT is the right one? Sounds risky!
EL
Elly
1 year ago
READ COMMITTED seems like a solid option too.
EZ
Ezekiel
1 year ago
But isn't SERIALIZABLE safer for data integrity?
NI
Nieves
1 year ago
Totally agree, SNAPSHOT avoids locking issues!
KE
Kerry
1 year ago
I think SNAPSHOT is the best choice for Azure SQL Data Sync.
MA
Marylin
1 year ago
I have a vague memory that SNAPSHOT helps with concurrency issues, but I need to double-check that.
TI
Tiffiny
1 year ago
I practiced a similar question, and I think READ COMMITTED is the default, but it might not be the best for syncing.
GL
Glory
1 year ago
I think I remember that SNAPSHOT isolation level is often recommended for data sync scenarios to avoid blocking.
CR
Crissy
1 year ago
I'm not entirely sure, but I feel like SERIALIZABLE might be too strict for this situation.
GL
Glenna
1 year ago
Hmm, I'm not too familiar with the NPSP features. I'll need to review the details on Levels, Engagement Plans, and General Accounting Units to see which one best fits the requirement of tracking restricted donations.
TI
Tiara
1 year ago
This looks like a pretty straightforward question. I think the best approach is to create a test class to execute the business logic and run the test in the Developer Console. That way, I can ensure the Apex class is working as specified by the requirements.