Salesforce Certified Platform Developer II — Question 250

A developer must create a custom pagination solution for accessing approximately 2000 records and displaying 50 records on each page. Data from Salesforce will be accessed via an API and not via Apex.
How can the developer meet these requirements? (Choose two.)

Answer options

• A. Use a StandardSetController
• B. Use CURSOR 50 in SOQL queries
• C. Use OFFSET in SOQL queries
• D. Use LIMIT 50 in SOQL queries

Correct answer: C, D

Explanation

The correct options, C and D, allow the developer to effectively manage pagination in SOQL queries. Using OFFSET enables the selection of records starting from a specific index, while LIMIT restricts the number of records returned to 50. Options A and B are not applicable as StandardSetController is tied to Apex, and CURSOR is not a valid SOQL syntax for pagination.