Consider the following queries. 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. Note that there are two fields that are marked as External Id on the Account. These fields are Customer_Number＿c and ERP_Key＿c.
Which two queries are optimized for large data volumes? (Choose two.)

A. SELECT Id FROM Account WHERE Name != '' AND IsDeleted = false

B. SELECT Id FROM Account WHERE Id IN :aListVariable

C. SELECT Id FROM Account WHERE Name != '' AND Customer_Number＿c = 'ValueA'

D. SELECT Id FROM Account WHERE Name != NULL








 

Suggested Answer: BC

Community Answer: BC



This question is in Certified Platform Developer II Exam
For getting Salesforce Certified Platform Developer II











Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Salesforce. 
Trademarks, certification & product names are used for reference only and belong to Salesforce.
The website does not contain actual questions and answers from Salesforce's Certification Exams.