An organization tracks safety compliance using custom objects. An administrator is tasked with connecting the Inspection_Audit__c object and the Compliance_Regulation__c object using a custom linking structure. The design must meet the following requirements:
1. Deleting an Inspection_Audit__c record must automatically delete all associated link records.
2. Deleting a Compliance_Regulation__c record must NOT delete associated link records, but instead clear the reference field value.
3. Executive managers must be able to view a real-time aggregate count of all linked audit regulations directly on each Inspection_Audit__c record.
Which two configuration actions should the administrator take to fulfill these requirements? Choose 2 answers.
- Create a Master-Detail relationship field on the link object referencing Inspection_Audit__c as the primary master.Answer
- BCreate a Master-Detail relationship field on the link object referencing Compliance_Regulation__c as a secondary master.
- Create a Lookup relationship field on the link object referencing Compliance_Regulation__c.Answer
- DCreate a Roll-Up Summary field on Compliance_Regulation__c to count the related link records across the lookup relationship.
Answer
The administrator must create a Master-Detail relationship field on the link object pointing to Inspection_Audit__c, and a Lookup relationship field on the link object pointing to Compliance_Regulation__c.
To satisfy the scenario requirements, a Master-Detail relationship must be defined on the link object pointing to Inspection_Audit__c so that child records are deleted when the audit is deleted and so that a Roll-Up Summary field can be created on Inspection_Audit__c. Concurrently, a Lookup relationship must be created on the link object pointing to Compliance_Regulation__c so that deleting a regulation does not cascade deletion to the link record.
Step-by-Step Solution
Key Concept
Object Relationships & Roll-Up Summary Eligibility