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 questions
Answer options
A: Create a new roll-up summary field called First Order Date, using Type MIN on the Opportunity Close Date with a filter where IsWon = TRUE. Correct answer
B: Create a new date field called First Order Date, create a new Workflow to set the date, and roll up the value with a filter where IsWon = TRUE.
C: Create a new roll-up summary field called First Order Date, using Type SUM on Opportunity Close Date.
D: Create a new date field called First Order Date, then create a roll-up summary to update the field using Type MIN.
Correct Answer:
A. Create a new roll-up summary field called First Order Date, using Type MIN on the Opportunity Close Date with a filter where IsWon = TRUE.
Explanation

To 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.

Why Incorrect

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.

References

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.

Scroll to Top