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 questions
Northern Trail Outfitters (NTO) wants to capture a list of customers that have bought a particular product. The solution architect has recommended to create a custom object for product, and to create a lookup relationship between its customers and its products. Products will be modeled as a custom object (NTO_ Product__ c) and customers are modeled as person accounts. Every NTO product may have millions of customers looking up a single product, resulting in a lookup skew. What should a data architect suggest to mitigate Issues related to lookup skew?
Answer options
A: Create multiple similar products and distribute the skew across those products. Correct answer
B: Change the lookup relationship to master-detail relationship.
C: Create a custom object to maintain the relationship between products and customers.
D: Select Clear the value of this field option while configuring the lookup relationship.
Correct Answer:
A. Create multiple similar products and distribute the skew across those products.
Explanation

Lookup 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.

Why Incorrect

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.

References

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.

Scroll to Top