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

You are Dynamics 36S Finance 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 correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A . One record cannot be selected for update by two different processes at the same time.
B . Records are locked as soon as they are retrieved from the database.
C . Records are locked for a shorter length of time.
D . Fewer resources are used to lock records during updates.
E . Records remain available for other processes while they are selected from the database.

View Answer

Answer: C,D,E

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.

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