ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 134 - MB-500 discussion

Report
Export

You are Dynamics 365 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 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.

Answers
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.

Answers
B.

Records remain available for other processes while they are selected from the database.

C.

Records are locked for a shorter length of time.

Answers
C.

Records are locked for a shorter length of time.

D.

Fewer resources are used to lock records during updates.

Answers
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.

Answers
E.

One record cannot be selected for update by two different processes at the same time.

Suggested answer: B, C, D

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.

E: One record can be selected for update by two different processes at the same time when using OCC.

Reference:

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

asked 05/10/2024
Guillaume Deterville
46 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first