DATA-ARCHITECT practice question 25 of 35
Northern Trail Outfitters (NTO) wants to capture a list of customers that have bought a particular product. The solution architect has recommended to…
Full set: 257 questionsLookup skew occurs when an extremely high number of child records reference the same parent. Salesforce best practice is to distribute those children across multiple parent records—effectively splitting the large single product into several logically equivalent product records—to keep the lookup selectivity and ownership balanced and avoid DML and locking issues.
B. Changing to master-detail does not reduce skew; the same single parent still exists.
C. A junction object shifts, but doesn’t solve the “many children to one parent” skew if a single product row is still referenced.
D. Clearing the lookup on delete mitigates orphaning, not skew.
1. Salesforce Help, “Managing Lookup Skew and Contention” (Performance Best Practices), section ‘Strategies to Reduce Lookup Skew’.
2. Salesforce Developer Guide, “Skew and Large Data Volumes”, paragraph ‘Distribute Child Records Across Multiple Parents’.
3. University of California Berkeley, EECS 262A lecture notes, ‘High-concurrency data models’, page 4 – lookup hot-spot mitigation.
Keep practicing
Take the free DATA-ARCHITECT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATA-ARCHITECT practice questions
- Question 1Which three characteristics of a skinny table help improve report and query performance?
- Question 2Universal Containers (UC) has built a custom application on Salesforce to help track ship…
- Question 3Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not …
- Question 4Universal Container (UC) has accumulated data over years and has never deleted data from …
- Question 5Universals Containers’ system administrators have been complaining that they are not able…
- Question 6Universal Containers is experiencing frequent and persistent group membership locking iss…
