Which two queries are optimized for large data volumes?

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 2 answers
A . SELECT Id FROM Account WHERE Id IN : aListVariable
B . SELECT Id FROM Account WHERE Name != ” AND IsDeleted = false
C . SELECT Id FROM Account WHERE Name != NULL
D . SELECT Id FROM Account WHERE Name != ” AND Customer Number c = ‘ValueA’

Answer: A,D

Latest PDII Dumps Valid Version with 280 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments