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

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

Contribute your Thoughts:

Submit Cancel

Tenesha

1 months 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

1 months 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

1 months 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

17 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

Anisha

6 days ago

Definitely, C and D seem to be the most selective queries for this scenario.

upvoted 0 times

...

Albert

18 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

21 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

2 months ago

I agree, C and D are the most selective queries for a large data set.

upvoted 0 times

...

Franklyn

3 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

3 months ago

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

upvoted 0 times

...

Solange

3 months ago

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

upvoted 0 times

...