Discuss Microsoft MB-500 Exam Topic 1 Question 21

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.

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

BRecords are locked as soon as they are retrieved from the database.

CRecords are locked for a shorter length of time.

DFewer resources are used to lock records during updates.

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

Suggested Answer: C, D, E

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.

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

Get Premium MB-500 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

11 comments · newest first

Filiberto 12 months ago

Wait, so records are still available while being selected? That’s surprising!

Shalon 1 year ago

Fewer resources used is a big win for performance!

Alesia 1 year ago

I’m not sure about that, locking seems safer to me.

Henriette 1 year ago

Totally agree, it’s way more efficient!

Renea 1 year ago

Optimistic concurrency lets multiple processes access records simultaneously.

Elizabeth 1 year ago

I recall that fewer resources are used during updates with optimistic concurrency. That was highlighted in one of our study sessions.

Orville 1 year ago

I'm not entirely sure, but I feel like locking records for a shorter time is also a benefit of optimistic concurrency. It seems to make sense, right?

Micah 1 year ago

I think optimistic concurrency control allows records to remain available for other processes, which is a big advantage. I remember that from our practice questions.

Lavonda 1 year ago

I’m confused about the locking part. I thought that pessimistic concurrency locks records immediately, but I’m not sure how that compares to optimistic concurrency.

Moon 1 year ago

This question seems to be asking about the differences between flex-algo LSPs and SR-TE LSPs. I'll need to carefully review the options and think about the key advantages of each approach.

Elena 1 year ago

Hmm, I'm a bit confused about the relationship between the MAC loopback and the PHY loopback. I'll need to review my notes on fault location techniques to make sure I understand this properly.

Microsoft MB-500 Exam - Topic 1 Question 21 Discussion