A Salesforce Administrator needs to configure a data model to link a custom Sponsor__c object with a custom Event__c object. A single sponsor can support multiple events, and an event can be supported by multiple sponsors. Additionally, management needs roll-up summary fields on both Event__c and Sponsor__c to track total funding raised per event and total contributions per sponsor.
Which two actions must the administrator take to fulfill these business requirements? (Select 2 answers)
- Create a custom junction object containing a Master-Detail relationship field to Event__c and another Master-Detail relationship field to Sponsor__c.Answer
- Create custom Roll-Up Summary fields on both the Event__c and Sponsor__c objects that aggregate data from the custom junction object records.Answer
- CCreate a custom junction object containing two Lookup relationship fields pointing to Event__c and Sponsor__c, then create Roll-Up Summary fields on the parent objects.
- DConfigure a Lookup relationship field on Event__c pointing to Sponsor__c and rely on record deletion to clear detail records without cascading.
Answer
The administrator must create a custom junction object with two Master-Detail relationships pointing to Event__c and Sponsor__c, and then create Roll-Up Summary fields on both parent objects to aggregate values from the junction records.
To implement a many-to-many relationship in Salesforce while supporting native Roll-Up Summary fields on both related objects, an administrator must create a custom junction object with two Master-Detail relationship fields (one for each parent object). This allows both parent objects to act as masters to the junction object, enabling Roll-Up Summary fields on both Event and Sponsor records.
Step-by-Step Solution
Key Concept
Many-to-Many Relationships and Roll-Up Summary Field Requirements