AI Associate AI Capabilities in CRM Practice Question
Exhibit
C:\> sfdx force:data:soql:query -q "SELECT Id, Score__c FROM Lead WHERE CreatedDate = TODAY" Rows: 2000 Time: 4.2s C:\> sfdx force:data:soql:query -q "SELECT Id, Score__c FROM Lead WHERE CreatedDate = LAST_N_DAYS:30" Rows: 45000 Time: 28.7s
Refer to the exhibit. An admin runs two queries on the Lead object. Both include the custom field Score__c used by Einstein Lead Scoring. The second query is significantly slower. What is the most likely cause?
⚠ Common exam trap
Salesforce often tests the misconception that Einstein features automatically index their underlying fields, when in fact custom fields like Score__c are not indexed by default and require manual indexing for query performance.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The query is not using a selective filter on Score__c
Einstein Lead Scoring uses the Score__c field to store lead scores, and the field is not indexed by default. When a query filters on Score__c without an index, it forces a full table scan on the Lead object, which becomes significantly slower as the number of leads grows. The second query likely includes a non-selective filter on Score__c (e.g., a range or inequality), which cannot leverage any existing index and thus degrades performance.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
The query is not using a selective filter on Score__c
Why this is correct
Large result set without index on Score__c causes slow performance.
- ✗
The query uses a date function that is not selective
Why it's wrong here
LAST_N_DAYS:30 is selective enough; the issue is row count and Score__c.
- ✗
The Score__c field is indexed
Why it's wrong here
Indexed fields would speed up, not slow down.
- ✗
The Einstein Lead Scoring job is running simultaneously
Why it's wrong here
No evidence of concurrent job.
Go deeper
Related to this question
About these practice questions
This AI Associate question is part of Courseiva's 753-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AI Associate practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AI Associate exam.