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 6 Question 42 Discussion

Universal Containers uses a custom Lightning page to provide a mechanism to perform a step-by-step wizard search for Accounts. One of the steps in the wizard is to allow the user to input text into a text field, ERP_Number__c, that is then used in a query to find matching Accounts.A developer receives the exception 'SOQL query not selective enough.Which step should be taken to resolve the issue?
D) Mark the ERP_Number__c field as required.
A) Move the SOQL query to within an asyncronous process.
B) Mark the lRP_Number__c field as an external ID.
C) Perform the SOQL query as part of a for loop.

Salesforce Certified Platform Developer II (Plat-Dev-301) Exam - Topic 6 Question 42 Discussion

Actual exam question for Salesforce's Salesforce Certified Platform Developer II (Plat-Dev-301) exam
Question #: 42
Topic #: 6
[All Salesforce Certified Platform Developer II (Plat-Dev-301) Questions]

Universal Containers uses a custom Lightning page to provide a mechanism to perform a step-by-step wizard search for Accounts. One of the steps in the wizard is to allow the user to input text into a text field, ERP_Number__c, that is then used in a query to find matching Accounts.

A developer receives the exception 'SOQL query not selective enough.

Which step should be taken to resolve the issue?

Show Suggested Answer Hide Answer
Suggested Answer: D

by Dalene at May 07, 2022, 07:52 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
Kenny
7 months ago
Definitely not a fan of using for loops for SOQL queries.
upvoted 0 times
...
Carin
7 months ago
Surprised this is even a problem, thought all fields were indexed!
upvoted 0 times
...
Alisha
7 months ago
No way, marking it as required won't fix the selectivity issue.
upvoted 0 times
...
Marti
8 months ago
I think moving the query to an async process could help too.
upvoted 0 times
...
Murray
8 months ago
Just mark ERP_Number__c as an external ID!
upvoted 0 times
...
Dorothy
8 months ago
I feel like marking the field as required might not directly solve the SOQL issue, but it could help with data integrity in the long run.
upvoted 0 times
...
Allene
8 months ago
I practiced a similar question where moving the query to an asynchronous process was suggested, but I wonder if that really fixes the selectivity issue here.
upvoted 0 times
...
Virgie
8 months ago
I think marking the ERP_Number__c field as an external ID could help with selectivity, but I’m not entirely confident about that.
upvoted 0 times
...
Tracey
8 months ago
I remember something about SOQL queries needing to be selective, but I'm not sure which option actually addresses that.
upvoted 0 times
...
King
8 months ago
Okay, let me walk through this step-by-step. I think the key is understanding how AD Query connects to the Domain Controllers.
upvoted 0 times
...
Mollie
8 months ago
Okay, let me break this down. The question is asking where we'd find certain types of project information. I'm leaning towards B - Communications management plan, since that's where we'd typically document things like status updates and risk analysis.
upvoted 0 times
...
Chantell
8 months ago
I think remuneration should be linked to performance, but I'm not sure if that's the only standard we should hold.
upvoted 0 times
...

Save Cancel