Universal Containers has a public sharing model for accounts and uses the parent account field to create a multi-level account hierarchy. When viewing a parent account, the company wants to see the total value of open opportunities for all accounts in the hierarchy. Which solution should a consultant recommend to meet this requirement?

A. Create a roll-up summary field on the parent account showing the total value of open opportunities from the child accounts.
B. Define a workflow rule to update the custom field on the parent account with the total value of open opportunities from the child accounts.
C. Create a link on the account that opens a report showing the total value of open opportunities for all accounts in the hierarchy.
D. Use Apex to update a custom field on the parent account with the total value of open opportunities from the child accounts.

Suggest answer: D

Reference: