Large data volumes, data skew and sharing recalculation
Spot account data, ownership and lookup skew, keep large loads and deletes fast (Bulk API batches, hard delete, truncate, PK chunking, skinny tables), and plan ownership transfers and deferred sharing calculation so a sales org still performs at projected volume.
Given a scenario, outline the scalability implications of a solution.
~8 min read · 21 practice questions ·
What the exam expects
- Recognize account data skew, ownership skew and lookup skew in a sales design and recommend the documented fix for each.
- Reduce record locking during big loads, and pick hard delete, truncate, PK chunking or a skinny table for a volume problem.
- Plan ownership transfers and deferred sharing calculation: what triggers recalculation, what deferral does not suspend, and what must happen afterwards.
- Frame scalability as a design responsibility: project growth, look for concentration, and prove performance in a full copy sandbox.
Key terms: data skew (more than 10,000 child records under one parent); ownership skew (one user owns a very large number of records of one object); lookup skew (a very large number of records point to one lookup record); sharing recalculation (re-evaluating sharing rules and group membership after access changes); hard delete (a Bulk API delete that bypasses the Recycle Bin).
Key facts
- Detail
- More than 10,000 child records on one parent
- Detail
- Give the skewed owner no role
- Detail
- 10,000 records max
- Detail
- 15 days or until it reaches its size limit; soft-deleted rows still excluded from queries
- Detail
- Bypasses the Recycle Bin; disabled by default
- Detail
- Tables over 10 million records or bulk queries that time out
- Detail
- Off by default; enabled by Customer Support
- Detail
- Inherit the master's security; keep under 10,000 per master
Sources for this section (5)
- Design Your Data Modeltrailhead.salesforce.com (opens in a new tab)
- Load Your Datatrailhead.salesforce.com (opens in a new tab)
- Perform Data Deletes and Extractstrailhead.salesforce.com (opens in a new tab)
- Defer Sharing Calculationshelp.salesforce.com (opens in a new tab)
- Object Relationships Overviewhelp.salesforce.com (opens in a new tab)
- Why does parking 200,000 contacts under one Unassigned account cause save errors?
- When should a consultant enable PK chunking?
- Why prefer hard delete over a normal delete for millions of obsolete records?
- Which activities trigger sharing rule recalculation?
The questions are free to read. Answers with their sources and self-grading are included with the pack.
Keep reading with the Agentforce Sales Consultant pack
- Core concepts
- Exam traps
- Worked scenario
The pack includes:
- All 20 lessons of the Agentforce Sales Consultant guide, with reading progress
- Interactive decision walks and step-by-step sequence steppers
- Inline practice questions and one-click topic practice (21 questions for this lesson)
- An official source cited for every claim
- An AI tutor that answers from the guide
- Unlimited timed practice exams