DATA-ARCHITECT practice question 6 of 35

Universal Containers is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and a automated updates at the same time. What should a data architect do in order to restore the issue?

Full set: 257 questions
Answer options
A: Enable granular locking Correct answer
B: Enable parallel sharing rule calculation.
C: Enable defer sharing calculation
D: Enable implicit sharing
Correct Answer:
A. Enable granular locking
Explanation

Group membership locking occurs when Salesforce recalculates sharing rules due to changes in roles, territories, or group memberships. On systems with large data volumes and complex sharing, these calculations can lock tables for extended periods, causing contention with other simultaneous updates. Granular locking is a feature specifically designed to resolve this by locking only the specific group membership records being processed, rather than entire tables. This significantly reduces the scope and duration of locks, allowing manual and automated updates to run concurrently without failure.

Why Incorrect

B. Parallel sharing rule calculation speeds up the recalculation process but does not inherently solve the table locking contention issue.
C. Deferring sharing calculation is a workaround to avoid contention by running calculations during off-peak hours; it doesn't fix the underlying locking problem.
D. Implicit sharing is a standard Salesforce sharing behavior (e.g., parent-child access) and is not a feature that can be enabled to solve lock contention.

References

1. Salesforce Help. (2023). Enable Granular Locking. "Granular locking allows for some group maintenance operations to proceed in parallel, which can result in a faster processing time... This feature helps reduce group membership lock errors on accounts, opportunities, and cases."

2. Salesforce Architects. (2022). Record-Level Access: Under the Hood. Salesforce. Page 23, "Sharing-Related Locking," discusses the problem of lock contention and mentions granular locking as a solution.

3. Salesforce Developer Blog. (2021, May 18). How to Avoid Lock Contention. This article details the causes of lock contention and recommends granular locking as a key mitigation strategy for group membership locks.

Scroll to Top