QuestionQ339

Implement security and optimize performance

You are a Dynamics 365 Finance developer.

You need to describe the performance benefits of the different concurrency models.

What are three performance advantages of optimistic concurrency control compared with pessimistic concurrency control? Each correct answer provides a complete solution.

> NOTE: Each correct selection is worth one point.

Choose three
  • 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.
  • E One record cannot be selected for update by two different processes at the same time.
Explanation

Optimistic concurrency leaves rows unlocked while they are read and detects a conflicting change when an update is attempted. This keeps records available to other processes, shortens lock duration, and reduces server resources required for record locking. Microsoft documents that optimistic concurrency does not lock rows on read and improves performance because record locks require additional server resources.

Learn more

Community Discussion

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