CRT-403 practice question 14 of 35
Cloud Kicks has five years of sales data and would like to track when customers made their first purchase. How should an app builder use a roll-up summary to meet the requirements?
Full set: 291 questionsTo track the first purchase date on a master record (e.g., Account) from related detail records (Opportunities), a roll-up summary field is the appropriate declarative tool. The configuration requires using the MIN aggregate function on the Opportunity Close Date field. This function identifies the earliest (minimum) date among the related records. Crucially, filter criteria must be applied to include only completed sales, which is achieved by filtering for opportunities where the IsWon field is TRUE. This ensures the roll-up calculates the date of the first actual purchase, not just the earliest created opportunity.
B: This is incorrect because a workflow rule is an unnecessarily complex solution. A roll-up summary field is the standard, declarative feature designed specifically for this type of aggregation and handles historical data automatically upon creation. C: This is incorrect because the SUM aggregate function cannot be used on a Date field; it is intended for numeric fields like Currency or Number. This option also omits the essential filter for won opportunities. D: This is incorrect as it misrepresents how roll-up summary fields function. You create a single field of the "Roll-Up Summary" data type; you do not create a separate date field that is then updated by the roll-up summary.
1. Salesforce Help Documentation, "Create a Roll-Up Summary Field": This document outlines the process for creating a roll-up summary field. In Step 4, it specifies the available summary types: "Choose the roll-up type: COUNT, SUM, MIN, or MAX." For the MIN type, it states, "Displays the lowest value... for date/time fields, the earliest date/time."
2. Salesforce Help Documentation, "Roll-Up Summary Field": This guide details the capabilities and considerations for roll-up summary fields. Under the "Filter Criteria for Roll-Up Summary Fields" section, it explains, "You can apply filter criteria to a roll-up summary field to specify which records in the detail object are included in the calculation." This supports the use of IsWon = TRUE to isolate actual purchases.
3. Salesforce Trailhead, "Create Object Relationships," Unit: "Create Roll-Up Summary Fields": This module provides hands-on instruction. It states, "For the roll-up type, 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 confirms that MIN is the correct function for finding the "first" or earliest date.
Keep practicing
Take the free CRT-403 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other CRT-403 practice questions
- Question 1Universal Containers is adding drone delivery to service offerings, and the developer has…
- Question 2An app builder at Ursa Major Solar has been working on a new custom app in a sandbox that…
- Question 3An app builder would like to streamline the user experience by reflecting summarized calc…
- Question 4The services manager wants to make sure the team enters case priority consistently. What …
- Question 5Ursa Major Solar wants to convert the relationship between Galaxy and Star from a lookup …
- Question 6Universal Containers has two types of applicants, hourly and salary. There are separate r…
