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 questionsRoll-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.
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.
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".
Keep practicing
Take the free DEX-403 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DEX-403 practice questions
- Question 1Which two solutions prevent a formula field from being referenced by a Roll-Up Summary Fi…
- Question 2Accounts at Universal Containers are currently readable by all users but editable only by…
- Question 3Universal Container wants customers to be able to open cases from a public-facing website…
- Question 4Properly installing managed packages helps prevent conflicts with customizations made by …
- Question 5Universal Containers (UC) has large data volumes and is nearing data storage limits. The …
- Question 6Cloud Kicks's management team frequently travels and wants to approve requests from their…
