Question

Difficulty: EasyStandard and Custom Object Management

An administrator at a higher education institution is building a custom data model to manage campus facilities. The institution requires that when a Venue custom object record is deleted, all associated Event Reservation custom object records are automatically deleted from the system as well. Which field configuration should the administrator implement on the Event Reservation object to support this requirement?

  1. Create a Master-Detail relationship field referencing the Venue object.Answer
  2. B
    Create a Lookup relationship field referencing the Venue object.
  3. C
    Create a Master-Detail relationship field on the Venue object referencing the Event Reservation object.
  4. D
    Create a Lookup relationship field with roll-up summary capability on the Event Reservation object.

Answer

The administrator should create a Master-Detail relationship field on the Event Reservation custom object that references the Venue custom object.
Creating a Master-Detail relationship field on the Event Reservation object pointing to the Venue object establishes Venue as the master and Event Reservation as the detail record. In a Master-Detail relationship, deleting the master record automatically cascades and deletes all related detail records, satisfying the requirement.

Step-by-Step Solution

1
Identify the parent and child objects based on business requirements.
Venue is the parent object, and Event Reservation is the child object.
The lifetime of an Event Reservation depends on the existence of the Venue.
2
Determine the necessary relationship behavior for deletion.
Cascading deletion is required so that removing a Venue automatically deletes all associated Event Reservations.
Master-Detail relationships strictly enforce cascade deletion of detail records when the master record is deleted.
3
Select the correct location for creating the relationship field.
The Master-Detail relationship field must be created on the detail object (Event Reservation).
In Salesforce, relationship custom fields are always defined on the child object pointing to the parent object.

Key Concept

Master-Detail Relationship Cascade Deletion
Rate this question