Microsoft MB-500 Exam - Topic 1 Question 21 Discussion

Actual exam question for Microsoft's MB-500 exam

Question #: 21
Topic #: 1

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.

Show Suggested Answer

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

by Shenika at May 05, 2022, 03:39 AM

Limited Time Offer

25%

Off

Get Premium MB-500 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Filiberto

4 months ago

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

upvoted 0 times

...

Shalon

5 months ago

Fewer resources used is a big win for performance!

upvoted 0 times

...

Alesia

5 months ago

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

upvoted 0 times

...

Henriette

5 months ago

Totally agree, it’s way more efficient!

upvoted 0 times

...

Renea

5 months ago

Optimistic concurrency lets multiple processes access records simultaneously.

upvoted 0 times

...

Elizabeth

5 months ago

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

upvoted 0 times

...

Orville

5 months 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?

upvoted 0 times

...

Micah

5 months 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.

upvoted 0 times

...

Lavonda

5 months 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.

upvoted 0 times

...

Moon

5 months 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.

upvoted 0 times

...

Elena

5 months 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.

upvoted 0 times

...