An administrator at a financial services enterprise is configuring a custom data model to manage client investment portfolios using a custom object Portfolio__c and individual assets using a custom object Holding__c. The business requires that the total monetary value of all related Holding__c records automatically aggregates on the parent Portfolio__c record, that deleting a Portfolio__c record automatically removes all associated Holding__c records, and that users can reassign a Holding__c record to a different Portfolio__c if registered incorrectly. Additionally, compliance officers require that sensitive financial compliance fields on Holding__c are restricted from unauthorized data access across all platform interfaces, including reports and APIs. Which architectural configuration correctly meets all requirements while maintaining data security?
- Create a Master-Detail relationship on Holding__c pointing to Portfolio__c, select the 'Allow reparenting' checkbox on the relationship field, create a Roll-Up Summary field on Portfolio__c, and enforce field access using Field-Level Security (FLS).Answer
- BCreate a Lookup relationship on Holding__c pointing to Portfolio__c, enable cascading deletion on the lookup definition, create a native Roll-Up Summary field on Portfolio__c, and configure Field-Level Security (FLS) for compliance fields.
- CCreate a Master-Detail relationship on Holding__c pointing to Portfolio__c without enabling reparenting, expecting child records to automatically orphan and persist if the master Portfolio__c record is deleted, while securing fields via Field-Level Security (FLS).
- DCreate a Master-Detail relationship on Holding__c pointing to Portfolio__c, select 'Allow reparenting', build a Roll-Up Summary field on Portfolio__c, and hide sensitive fields from unauthorized users solely using Dynamic Forms component visibility rules.