Exam Plat-Dev-301 Topic 1 Question 24 Discussion

Actual exam question for Salesforce's Plat-Dev-301 exam
Question #: 24
Topic #: 1
Consider the queries in the options below and the following Information:
* For these queries, assume that there are more than 200,000 Account records.
* These records Include soft-deleted records; that is, deleted records that are still in the Recycle Bin.
* There are two fields that are marked as External Id on the
Account. These fields are customer_Number_c and ERR_Key_ s.
Which two queries are optimized for large data volumes?
Choose 2 answers

Suggested Answer: B,D Vote an answer

For optimizing queries, especially on large data volumes, it's recommended to use indexed fields such as External ID fields, which will make the queries selective. Among the options given:
B) is optimized because it is using the Customer_Number__c field, which is an External ID and hence indexed.
D) is also optimized because it filters out deleted records with IsDeleted = false and uses Name != ' ', which is likely to be selective.
Using indexed fields and filtering out unnecessary records helps in faster query execution on large data volumes.
Make SOQL Query Selective
Working with Very Large SOQL Queries

by Ansel at May 29, 2026, 02:23 AM

Limited Time Offer

15%

Off

Get Premium Plat-Dev-301 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10