Salesforce Exam Platform Developer II Topic 9 Question 72 Discussion

Actual exam question for Salesforce's Platform Developer II exam

Question #: 72
Topic #: 9

[All Platform Developer II Questions]

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

Choose 2 answers

ASELECT Id FROM Account WHERE Name LIKE '!-NULL

BSELECT Id FRCM Account WHERE Name != ' '

CSELECT Id FRCM Account WHEP Name IN (List of Names) AND Customer_Number_c= 'ValueA

DSELECT Id FROM Account WHERE II IK (List of Account Ida)

Show Suggested Answer

Suggested Answer: C, D

by Deeanna at Apr 23, 2023, 12:46 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

9 days ago

C and D look like the most selective queries to me. The IN clause and the list of account IDs should be able to handle a large data set efficiently.

upvoted 0 times

...

20 days ago

I'm not sure about A and C. I think B and D could also work well for this scenario.

upvoted 0 times

...

22 days ago

I agree with you, Solange. A and C are the best options for large data sets.

upvoted 0 times

...

25 days ago

I think A and C are selective queries because they have specific conditions.

upvoted 0 times

...