Salesforce Certified Platform App Builder Practice Questions

Salesforce Certified Platform App Builder exam preparation

Salesforce Certified Platform App Builder practice questions in English: 180 questions with explanations. The mock exam has 60 questions and 105 minutes.

Salesforce Certified Platform App Builder free question 3 / 10 · Domain 2: Data Modeling and Management

Account is the master of the custom object Project, and Project is the master of the custom object Task (a multilevel master-detail chain: Account to Project to Task). The account page should show the total of the Hours field across all Tasks under that account. Which way of building it matches the Help description?

  1. Create a roll-up summary field on Project that sums Task hours, then create a roll-up summary on Account that sums that field
  2. Roll-up summary fields are unavailable in multilevel master-detail relationships, so report on hours totals by account and project
  3. Create a roll-up summary field on Task that rolls the hours up to the account
  4. Create a roll-up summary field on Account that sums Task hours directly; a master can aggregate fields at any level beneath it
Show the answer and explanation

Answer: A

Why this is correct
"Considerations for Object Relationships" says roll-up summary fields work in multilevel master-detail relationships just as they do between two objects. A master can summarize fields on its detail records, but it cannot summarize fields on grandchild detail records directly. If you put a roll-up summary field on the detail that summarizes the grandchild's field, the master can summarize that field. From Account, Task hours are reached through the roll-up on Project.

Why the other options are wrong
"Create a roll-up summary field on Account that sums Task hours directly; a master can aggregate fields at any level beneath it" … A master can summarize fields on its direct detail records, not on detail-of-detail (grandchild) records. You cannot make a field on Account that sums Task hours directly.
"Create a roll-up summary field on Task that rolls the hours up to the account" … A roll-up summary field lives on the master side of the relationship and summarizes the directly related records on the detail side. It is not placed on the detail to summarize upward to the master.
"Roll-up summary fields are unavailable in multilevel master-detail relationships, so report on hours totals by account and project" … Help says roll-up summary fields work in multilevel master-detail relationships as they do between two objects. With the roll-up placed on the detail, the total can be shown as an Account field.

Multilevel points
You can build custom detail hierarchies up to three levels deep. Multilevel master-detail relationships can be used in custom report types; select Allow Reports when you create the custom object. Custom report types for multilevel relationships count toward the org's limit on custom report types.

Go to the Salesforce Certified Platform App Builder practice app (10 free questions; purchase unlocks all questions)

See the full practice set