Question

Difficulty: EasyObject Relationships (Lookup, Master-Detail, Many-to-Many)

A Salesforce administrator is designing a custom data model to link a parent object, Event_Project__c, to a child object, Deliverable__c. The business requires that deleting an Event_Project__c record automatically deletes all associated Deliverable__c records. Which two statements correctly describe the capabilities and behavior of configuring a Master-Detail relationship for this requirement? (Choose 2 answers)

  1. Deleting an Event_Project__c record automatically deletes all related Deliverable__c records.Answer
  2. Roll-up summary fields can be created on Event_Project__c to aggregate data from Deliverable__c records.Answer
  3. C
    Deliverable__c records will remain in the system as orphaned records when the parent Event_Project__c record is deleted.
  4. D
    Roll-up summary fields can only be created on a Lookup relationship and cannot be used on Master-Detail relationships.

Answer

The correct statements are that deleting an Event_Project__c record automatically deletes all related Deliverable__c records, and roll-up summary fields can be created on Event_Project__c to aggregate data from Deliverable__c records.
In a Master-Detail relationship, the detail record's lifecycle is tied to the master record, so deleting the master automatically deletes all detail records. Furthermore, Master-Detail relationships enable roll-up summary fields on the master object to aggregate child values.

Step-by-Step Solution

1
Identify the relationship type that supports cascading deletes.
Master-Detail relationships inherently perform cascading deletes of child records when the master record is deleted.
This directly fulfills the business requirement of deleting associated deliverable records automatically.
2
Identify additional features unlocked by a Master-Detail relationship.
Master-Detail relationships allow roll-up summary fields on the master object.
The master record can summarize values such as record counts, totals, or minimum/maximum values from detail records.

Key Concept

Master-Detail Relationship Behavior and Roll-Up Summary Capabilities
Rate this question