Notifications
Clear all
Topic starter
23/08/2022 9:28 pm
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’
Suggested Answer: A,D