Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

Show Suggested Answer Hide Answer
Suggested Answer: C, D

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

Limited Time Offer

25%

Off

Get Premium Platform Developer II Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Tenesha
23 days ago
Hmm, B looks like it could work, but the '!= ' ' ' part is a bit suspicious. I'll go with C and D to play it safe.
upvoted 0 times
...
Lashawnda
25 days ago
I'm just glad they didn't include an option that says 'SELECT * FROM Account'. Talk about a performance nightmare!
upvoted 0 times
...
Hayley
28 days ago
Ah, the old 'NULL' in the LIKE clause trick. Classic SOQL gotcha! I'll steer clear of A and B.
upvoted 0 times
Annamaria
7 days ago
I think C and D are the selective SOQL queries for large data sets.
upvoted 0 times
...
...
Essie
1 months ago
Haha, 'WHEP' instead of 'WHERE'? Someone needs to proofread these options a bit better. But C and D do seem like the best choices.
upvoted 0 times
Albert
8 days ago
Yeah, C and D are the ones that make the most sense for a large data set like that.
upvoted 0 times
...
Tricia
11 days ago
I agree, 'WHEP' is definitely a typo. But C and D do look like the most suitable options.
upvoted 0 times
...
...
Sherman
2 months 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
Nikita
1 months ago
Yes, the IN clause and list of account IDs should help with efficiency.
upvoted 0 times
...
Nikita
1 months ago
I agree, C and D are the most selective queries for a large data set.
upvoted 0 times
...
...
Franklyn
2 months ago
I'm not sure about A and C. I think B and D could also work well for this scenario.
upvoted 0 times
...
Carole
2 months ago
I agree with you, Solange. A and C are the best options for large data sets.
upvoted 0 times
...
Solange
2 months ago
I think A and C are selective queries because they have specific conditions.
upvoted 0 times
...

Save Cancel