Object Manager and Lightning App Builder15% of the exam

Standard objects, relationships and Schema Builder

How standard and custom objects connect through lookup, master-detail, junction and hierarchical relationships, what each relationship does to deletion, ownership, sharing and roll-ups, and where record types and Schema Builder fit in the data model.

Official exam objective
Describe the standard object architecture and relationship model (for example: standard object, parent/child, master detail/lookup/junction relationships, record types, Schema Builder).

~7 min read · 17 practice questions

What the exam expects

  • Recognise when a delivered standard object or standard junction (Opportunity Contact Roles, Campaign Members) already meets a requirement, before building a custom object.
  • Choose between lookup, master-detail, many-to-many (junction), hierarchical and external relationships from requirements about deletion, ownership, sharing, required values and roll-ups.
  • Predict the effects of changing a relationship: converting lookup to master-detail and back, enabling reparenting, and the per-object relationship limits.
  • Explain how record types present different picklist values, business processes and page layouts on the same object.
  • Use Schema Builder to view and build objects, fields and relationships, and know what it cannot do.

Key facts

Default lookup delete behaviour
Detail
Clear the value of this field
Delete this record also
Detail
Custom lookup on a custom object only; disabled until Salesforce enables it
Reparenting detail records
Detail
Blocked unless Allow reparenting is selected
Lookup to master-detail
Detail
Every record must have a lookup value
Master-detail to lookup
Detail
Blocked while roll-ups exist on the master
Junction primary relationship
Detail
First master-detail created; drives look, owner and division
Schema Builder cannot add
Detail
Geolocation fields
Sources for this section (3)
  • Which editions include Schema Builder, and is it on by default?
  • When would an admin create an indirect lookup relationship?
  • Which fields can a validation rule on a junction object reference?
  • Why can a Bug record point to another Bug record?
  • How many custom detail levels can a chain of master-detail relationships have?

The questions are free to read. Answers with their sources and self-grading are included with the pack.

Keep reading with the Platform Administrator pack

  • Core concepts
  • Exam traps
  • Worked scenario

The pack includes:

  • All 28 lessons of the Platform Administrator guide, with reading progress
  • Interactive decision walks and step-by-step sequence steppers
  • Practice exams purchase adds inline bank questions and topic practice (17 questions for this lesson)
  • An official source cited for every claim
  • An AI tutor that answers from the guide
  • Choose guide-only, practice-only, or save $4 with both

Practice for the Platform Administrator exam