nerdexam
Salesforce

PDII · Question #358

Which two queries are selective SOQL queries and can be used for a large data set of 200,000 Account records? (Choose two.)

The correct answer is A. SELECT Id FROM Account WHERE Id IN (List of Account Ids) B. SELECT Id FROM Account WHERE Name IN (List of Names) AND Customer_Number__c =. See the full explanation below for the reasoning.

Question

Which two queries are selective SOQL queries and can be used for a large data set of 200,000 Account records? (Choose two.)

Options

  • ASELECT Id FROM Account WHERE Id IN (List of Account Ids)
  • BSELECT Id FROM Account WHERE Name IN (List of Names) AND Customer_Number__c =
  • CSELECT Id FROM Account WHERE Name LIKE '%Partner'
  • DSELECT Id FROM Account WHERE Name != ' '

How the community answered

(20 responses)
  • A
    80% (16)
  • C
    5% (1)
  • D
    15% (3)

Community Discussion

No community discussion yet for this question.

Full PDII Practice