SHARING-AND-VISIBILITY-DESIGNER practice question 27 of 30
A dummy user at Universal Containers owns more that 10,000 lead records. The system assigned all these leads to a dummy user. This is causing performance issues whenever role hierarchy changes. Which two options should be recommended to improve performance? Choose 2 answers.
Full set: 212 questionsThis scenario describes ownership data skew, where a single user owns a vast number of records, causing performance degradation during sharing recalculations triggered by role hierarchy changes. The two primary strategies to mitigate this are to remove the skewed owner from processing and to reduce the skew itself. Not assigning a role to the dummy user (D) removes them from the role hierarchy, so their records are not processed during hierarchy-based sharing recalculations. Additionally, distributing the records among multiple users (A) reduces the concentration of ownership, minimizing the impact of any single user's records on performance.
B. Adding the user to a public group is for sharing records to a set of users; it does not resolve performance issues related to record ownership.
C. Placing the user at the bottom of the hierarchy helps but is less effective than removing the role entirely, as they are still part of the hierarchy.
1. Salesforce Architects. (2022). Designing Record Access for Enterprise Scale. Section: "Data Skew". "Ownership skew... To mitigate this, don’t assign the user to a role. If the user requires a role, place them in a separate role at the top of the hierarchy... Also, distribute records as evenly as possible across the owners."
2. Salesforce Help. (2023). Record-Level Access: Under the Hood. "To avoid performance issues with role hierarchy changes, don't assign a role to users that own a large number of records (for example, more than 10,000)."
3. Salesforce Trust. (2021). Best Practices for Deployments with Large Data Volumes. Section: "Record Ownership". "Distribute ownership of records across as many users as possible... For integration users or other users who own a large number of records, do not assign them a role in the role hierarchy."
Keep practicing
Take the free SHARING-AND-VISIBILITY-DESIGNER practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SHARING-AND-VISIBILITY-DESIGNER practice questions
- Question 1Universal Containers is a fast-growing company that sells containers globally. It has tho…
- Question 2Universal Containers uses 75,000 distributors that have close to 1 million total users. D…
- Question 3Universal Containers would like to create a custom team solution that can be used on a cu…
- Question 4Universal Containers has a private sharing model on Accounts. Apex Managed Sharing is req…
- Question 5Universal Containers keeps product brochures in Salesforce as files. Sarah shares a publi…
- Question 6What is the best practice for testing sharing and visibility changes?
