Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 4 Question 53 Discussion

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?
B) SNAPSHOT
A) SERIALIZABLE
C) READ UNCOMMITTED
D) READ COMMITTED

Microsoft DP-300 Exam - Topic 4 Question 53 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 53
Topic #: 4
[All DP-300 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

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

by Sabra at May 05, 2022, 07:56 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Matilda
7 months ago
Wait, are we sure SNAPSHOT is the right one? Sounds risky!
upvoted 0 times
...
Elly
7 months ago
READ COMMITTED seems like a solid option too.
upvoted 0 times
...
Ezekiel
8 months ago
But isn't SERIALIZABLE safer for data integrity?
upvoted 0 times
...
Nieves
8 months ago
Totally agree, SNAPSHOT avoids locking issues!
upvoted 0 times
...
Kerry
8 months ago
I think SNAPSHOT is the best choice for Azure SQL Data Sync.
upvoted 0 times
...
Marylin
8 months ago
I have a vague memory that SNAPSHOT helps with concurrency issues, but I need to double-check that.
upvoted 0 times
...
Tiffiny
8 months ago
I practiced a similar question, and I think READ COMMITTED is the default, but it might not be the best for syncing.
upvoted 0 times
...
Glory
8 months ago
I think I remember that SNAPSHOT isolation level is often recommended for data sync scenarios to avoid blocking.
upvoted 0 times
...
Crissy
8 months ago
I'm not entirely sure, but I feel like SERIALIZABLE might be too strict for this situation.
upvoted 0 times
...
Glenna
8 months 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.
upvoted 0 times
...
Tiara
8 months 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.
upvoted 0 times
...

Save Cancel