DEX-403 practice question 20 of 35

An app builder would like to streamline the user experience by reflecting summarized calculations of specific fields on various objects. Which field types could be used in roll-up summary fields to accomplish this? Choose 3 answers

Full set: 291 questions
Answer options
A: Currency Correct answer
B: Percent Correct answer
C: Date
D: Checkbox Correct answer
E: Time
Correct Answer:
A. Currency; B. Percent; D. Checkbox
Explanation

Roll-up summary fields aggregate data from child records in a master-detail relationship. The calculations can be SUM, COUNT, MIN, or MAX. Currency (A) and Percent (B) fields are valid source fields for SUM, MIN, and MAX calculations, making them primary candidates for numeric summaries. Checkbox (D) fields, while not directly aggregated through SUM, MIN, or MAX, are commonly used in the filter criteria for a COUNT roll-up. This allows for summarized calculations such as counting the number of child records where a specific condition is true (e.g., IsActivec = TRUE), directly reflecting a summary of that field's values across records.

Why Incorrect

C. Date: While Date fields can be used for MIN and MAX roll-ups, the question emphasizes broader "summarized calculations," where SUM and COUNT are often considered more representative than the single-value retrieval of MIN/MAX.
E. Time: Similar to Date fields, Time fields are restricted to MIN and MAX calculations and are not as versatile for the full range of summary aggregations as the correct options.

References

1. Salesforce Help Documentation: "Roll-Up Summary Field"

Reference: This document outlines the types of calculations available. It states, "You can perform different types of calculations... You can count the number of detail records, or calculate the sum, minimum value, or maximum value of a field in the detail records." This supports the concept of varied summary calculations.

Source: Salesforce Help, Article "Roll-Up Summary Field".

2. Salesforce Help Documentation: "Create a Roll-Up Summary Field"

Reference: In the steps for creating a roll-up summary field, Step 4 ("Select the field to aggregate") specifies that for SUM, the field can be Number, Currency, or Percent. This directly supports options A and B.

Source: Salesforce Help, Article "Create a Roll-Up Summary Field".

3. Salesforce Help Documentation: "Considerations for Roll-Up Summary Fields"

Reference: This document details limitations and usage. While it doesn't list Checkbox as an aggregatable field type, the functionality to "Select the filter criteria" (Step 5 in the creation process) is a core part of the feature. Checkbox fields are a primary field type used for these criteria to perform conditional counts, thus supporting option D's inclusion as a field "used in" the roll-up process.

Source: Salesforce Help, Article "Considerations for Roll-Up Summary Fields".

Scroll to Top