PLAT-DEV-210 practice question 25 of 25

A developer needs to limit the of a DataRaptorExtract to a maximum of one result. How should the developer configure this?

Full set: 103 questions
Answer options
A: Define a formula with the Filter function
B: Use a Custom Output Type when creating the DataRaptor
C: Use the LIMIT filter on the Extract definition Correct answer
D: Set the Limit Property on the Action that calls the DataRaptor Extract.
Correct Answer:
C. Use the LIMIT filter on the Extract definition
Explanation

The most direct and efficient way to limit the number of records returned by a DataRaptor Extract is to use the LIMIT filter property within the 'Extract' step's configuration. This property directly translates to the LIMIT clause in the underlying SOQL query that the DataRaptor generates. By setting this value to '1', the developer instructs the database to stop searching and return only the very first record that matches the filter criteria, which is the intended and most performant solution.

Why Incorrect

A. A formula with a Filter function processes data after it has been extracted from the database, which is inefficient for limiting the initial query.
B. The Output Type (e.g., JSON) defines the format of the output data, not the quantity of records retrieved from the source sObject.
D. The primary configuration for limiting a query's result set resides within the DataRaptor itself, not in the properties of a calling Action.

References

1. Salesforce OmniStudio Documentation, DataRaptors, "DataRaptor Extract Tab": In the section describing the properties for an sObject in the Extract step, the LIMIT field is defined. The documentation states, "Limits the number of records returned. Equivalent to the SOQL LIMIT clause." This confirms that LIMIT is the designated feature for this purpose.

2. Salesforce OmniStudio Developer Guide, "Create a DataRaptor Extract": The guide details the steps for building a DataRaptor Extract. In the section covering the 'Extract' tab, it illustrates the use of filters, including ORDER BY and LIMIT, as the standard mechanism for controlling the data set returned by the SOQL query.

Scroll to Top