An administrator at a financial services firm is configuring a custom data model to manage vendor compliance. Each Security Audit record must be linked to a parent Vendor record. The business requirements specify that deleting a Vendor record must automatically delete all associated Security Audit records. Furthermore, compliance managers must be able to view a real-time aggregate total of completed Security Audits directly on the Vendor record detail page using standard declarative functionality.
Which relationship type should the administrator establish on the Security Audit object to fulfill these requirements?
- Create a Master-Detail relationship field on the Security Audit object referencing the Vendor object.Answer
- BCreate a Lookup relationship field on the Security Audit object and add a Roll-Up Summary field on the Vendor object.
- CCreate a Master-Detail relationship field on the Vendor object referencing the Security Audit object.
- DCreate a Many-to-Many relationship using a custom junction object between Vendor and Security Audit.
Answer
Create a Master-Detail relationship field on the Security Audit object referencing the Vendor object.
Establishing a Master-Detail relationship on the Security Audit custom object with Vendor as the master satisfies both key business requirements natively: deleting a Vendor automatically cascades deletion to child Security Audit records, and administrators can immediately build a standard Roll-Up Summary field on Vendor to count related audits.
Step-by-Step Solution
Key Concept
Master-Detail Relationship Capabilities and Roll-Up Summary Field Dependencies
Estimated Time:1m 30s