Universal Containers uses a custom object named Project__c to track consulting engagements and a custom object named Consultant__c to manage staff availability. A Salesforce Administrator must establish a relationship structure using a custom object named Assignment__c to link consultants to projects. The business requirements state that:
1. Deleting a Project__c record must automatically delete all related Assignment__c records.
2. Deleting a Consultant__c record must leave the related Assignment__c records intact while clearing the consultant reference.
3. Administrators must be able to create Roll-Up Summary fields on the Project__c object to calculate total billable hours from related Assignment__c records.
Which relationship configuration on the Assignment__c object satisfies all of these requirements?
- Create a Master-Detail relationship pointing to Project__c and a Lookup relationship pointing to Consultant__c.Cevap
- BCreate a Lookup relationship pointing to Project__c with cascade delete enabled and a Lookup relationship pointing to Consultant__c.
- CCreate a Master-Detail relationship pointing to both Project__c and Consultant__c, enabling reparenting on the Consultant__c relationship.
- DCreate a Lookup relationship pointing to Project__c and a Master-Detail relationship pointing to Consultant__c.