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 Certified Platform Developer II (Plat-Dev-301) Exam - Topic 9 Question 72 Discussion

Which two queries are selective SOQL queries and can be used for a large data set of 200,000 Account records?Choose 2 answers
C) SELECT Id FRCM Account WHEP Name IN (List of Names) AND Customer_Number_c= 'ValueA and D) SELECT Id FROM Account WHERE II IK (List of Account Ida)
A) SELECT Id FROM Account WHERE Name LIKE '!-NULL
B) SELECT Id FRCM Account WHERE Name != ' '

Salesforce Certified Platform Developer II (Plat-Dev-301) Exam - Topic 9 Question 72 Discussion

Actual exam question for Salesforce's Salesforce Certified Platform Developer II (Plat-Dev-301) exam
Question #: 72
Topic #: 9
[All Salesforce Certified Platform Developer II (Plat-Dev-301) 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 Salesforce Certified Platform Developer II (Plat-Dev-301) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Chantay
7 months ago
A has a syntax error, so it can't be selective.
upvoted 0 times
...
Roxane
7 months ago
Wait, what’s wrong with D? It looks like it should work!
upvoted 0 times
...
Aleshia
7 months ago
C looks good, but D seems off to me.
upvoted 0 times
...
Toshia
8 months ago
I think B is selective too, but not sure about A.
upvoted 0 times
...
Val
8 months ago
A and C are definitely selective queries.
upvoted 0 times
...
Stevie
8 months ago
I'm a bit confused about option D; I thought using IN with a list of IDs could be selective, but I can't recall if it always is.
upvoted 0 times
...
Ming
8 months ago
I practiced a similar question where we had to identify selective queries, and I feel like option A might not be selective enough.
upvoted 0 times
...
Catrice
8 months ago
I think option C looks good because it uses an IN clause, which can be selective if the list is small enough.
upvoted 0 times
...
Roosevelt
8 months ago
I remember that selective queries should filter down the results significantly, but I'm not sure about the syntax in option B.
upvoted 0 times
...
Lourdes
8 months ago
Hmm, I'm a bit confused on this one. I know the different log levels, but I'm not sure which one is always enabled. I'll have to think this through carefully.
upvoted 0 times
...
Yuki
8 months ago
Hmm, I'm a bit unsure about this one. There are a lot of options, and I want to make sure I understand the differences between them. I'll need to review the Scrum Guide to refresh my memory on the Sprint Backlog creation process.
upvoted 0 times
...
Alease
8 months ago
I thought the Window tool belonged to the Insert tab, but I'm not completely confident about that.
upvoted 0 times
...
Corinne
8 months ago
Okay, let me think this through step-by-step. The regular expression seems to be looking for a specific sequence of digits and letters.
upvoted 0 times
...
Tenesha
1 year 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 year 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 year ago
Ah, the old 'NULL' in the LIKE clause trick. Classic SOQL gotcha! I'll steer clear of A and B.
upvoted 0 times
Ira
11 months ago
Let's go with C and D to avoid any potential pitfalls with A and B.
upvoted 0 times
...
Antonette
11 months ago
C and D are definitely safer choices for querying a large number of Account records.
upvoted 0 times
...
Gregoria
11 months ago
Yeah, A and B could cause some issues with the LIKE and != operators.
upvoted 0 times
...
Annamaria
1 year ago
I think C and D are the selective SOQL queries for large data sets.
upvoted 0 times
...
...
Essie
1 year 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
12 months ago
Definitely, C and D seem to be the most selective queries for this scenario.
upvoted 0 times
...
Albert
1 year ago
Yeah, C and D are the ones that make the most sense for a large data set like that.
upvoted 0 times
...
Tricia
1 year ago
I agree, 'WHEP' is definitely a typo. But C and D do look like the most suitable options.
upvoted 0 times
...
...
Sherman
1 year 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 year ago
Yes, the IN clause and list of account IDs should help with efficiency.
upvoted 0 times
...
Nikita
1 year ago
I agree, C and D are the most selective queries for a large data set.
upvoted 0 times
...
...
Franklyn
1 year 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
1 year ago
I agree with you, Solange. A and C are the best options for large data sets.
upvoted 0 times
...
Solange
1 year ago
I think A and C are selective queries because they have specific conditions.
upvoted 0 times
...

Save Cancel