Salesforce
PDII · Question #288
PDII Question #288: Real Exam Question with Answer & Explanation
The correct answer is B. SELECT Id FROM Account WHERE Id IN :aListVariable C. SELECT Id FROM Account WHERE Name != '' AND Customer_Number_c = 'ValueA'. See the full explanation below for the reasoning.
Question
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.)
Options
- ASELECT Id FROM Account WHERE Name != '' AND IsDeleted = false
- BSELECT Id FROM Account WHERE Id IN :aListVariable
- CSELECT Id FROM Account WHERE Name != '' AND Customer_Number_c = 'ValueA'
- DSELECT Id FROM Account WHERE Name != NULL
Community Discussion
No community discussion yet for this question.