Salesforce Certified Data Architect — Question 61
A national nonprofit organization is using Salesforce to recruit members. The recruitment process requires a member to be matched with a volunteer opportunity. Given the following:
1. A record is created in Project__c and used to track the project through completion.
2. The member may then start volunteering and is required to track their volunteer hours, which is stored in VTOTime__c object related to the project.
3. Ability to view or edit the VTOTime__c object needs to be the same as the Project__c record.
4. Managers must see total hours volunteered while viewing the Project__c record.
Which data relationship should the data architect use to support this requirement when creating the custom VTOTime__c object?
Answer options
- A. Master Detail field on Project__c to VTOTime__c showing a list of VTOTime__c Records in a related list.
- B. Lookup field on VTOTime__c to Project__c with formula filed on Project__c showing Sum of hours from VTOTime__c records.
- C. Lookup Field on Project__c to VTOTime__C displaying a list of VTOTime__C in a related list.
- D. Master Detail Field on VTOTime__c to Project__c with rollup summary field on Project__c showing sum of hours from VTOTime__c records.
Correct answer: D
Explanation
The correct answer is D because a Master Detail relationship allows for the creation of a roll-up summary field on the Project__c record, enabling the total volunteer hours to be displayed directly on that record. This is essential for meeting the requirement that managers need to see the total hours volunteered. The other options do not provide the necessary roll-up capability or do not align the permissions as required.