Question

Difficulty: MediumFormula Fields and Roll-Up Summary Fields

A Salesforce Administrator needs to aggregate financial metrics on a custom parent object, Hotel_Property__c, using values from child Guest_Reservation__c records. The requirement is to display the total revenue of completed stays directly on the Hotel_Property__c record.

Which two requirements or considerations apply when configuring a Roll-Up Summary field for this scenario?

  1. A Master-Detail relationship must exist between Hotel_Property__c and Guest_Reservation__c, with Hotel_Property__c designated as the master object.Answer
  2. All Roll-Up Summary fields on Hotel_Property__c that reference Guest_Reservation__c must be deleted before converting the relationship from Master-Detail to Lookup.Answer
  3. C
    Standard Roll-Up Summary fields can be created on Hotel_Property__c even if Guest_Reservation__c is connected via a standard Lookup relationship.
  4. D
    Deleting a Hotel_Property__c record will leave related Guest_Reservation__c records intact while clearing their relationship lookup fields.

Answer

The administrator must ensure a Master-Detail relationship exists with Hotel_Property__c as the master object, and must delete any existing Roll-Up Summary fields before converting the relationship to a Lookup relationship in the future.
Standard Roll-Up Summary fields are exclusively available on the master object of a Master-Detail relationship. Furthermore, Salesforce schema integrity rules mandate that any existing Roll-Up Summary fields referencing a detail object must be removed before converting that Master-Detail relationship into a Lookup relationship.

Step-by-Step Solution

1
Verify object relationship prerequisites for Roll-Up Summary fields.
Roll-Up Summary fields are native only to the master side of a Master-Detail relationship.
Standard declarative roll-up summaries require tight master-detail coupling to maintain data integrity.
2
Evaluate relationship conversion constraints and deletion behaviors.
Converting Master-Detail to Lookup requires deleting all Roll-Up Summary fields first; deleting a master record cascades deletion to all detail records.
Salesforce enforces schema integrity dependency rules during relationship conversions and deletions.

Key Concept

Roll-Up Summary Field Capabilities and Relationship Constraints
Rate this question