Salesforce Certified Data Architect — Question 18

Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing. UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and
UC is experiencing "lock errors" consistently.
What should a data architect recommend to mitigate these errors?

Answer options

• A. Remove SOQL statements from Apex Loops.
• B. Enable sharing recalculations.
• C. Ask Salesforce support for additional CPU power.
• D. Enable granular locking.

Correct answer: D

Explanation

Enabling granular locking allows for more precise control over record locks, which can reduce conflicts between automated and manual processes, thereby mitigating lock errors. The other options, while addressing different performance issues, do not specifically target the problem of overlapping automated and manual processes leading to lock errors.