What are three performance advantages of optimistic concurrency control over pessimistic concurrency control?

Question Set 2

You are Dynamics 365 Finance and Operations developer.

You need to explain the performance advantages of the different concurrency models.

What are three performance advantages of optimistic concurrency control over pessimistic concurrency control? Each control answer presents a complete solution. NOTE: Each correct selection is worth one point.
A . Records are locked as soon as they are retrieved from the database.
B . Records remain available for other processes while they are selected from the database.
C . Records are locked for a shorter length of time.
D . Fewer resources are used to lock records during updates.

View Answer

Answer: BCD

Explanation:

Optimistic Concurrency only locks records from the time when the actual update is performed.

Following are the advantages of using OCC:

Records remain available for other processes to update if they have been selected from the database but haven’t yet been updated.

Records are locked for a shorter length of time.

Fewer resources are used to hold the locks during the update process.

Incorrect Answers:

A: Pessimistic Concurrency Control locks records as soon as they are fetched from the database for an update.

Reference: https://docs.microsoft.com/en-us/dynamicsax-2012/developer/optimistic-concurrency-control