SALESFORCE-PD1 Process Automation And Logic Practice Question
A developer has written a trigger on the Account object that performs a SOQL query inside a for-loop. The developer notices that when a data load of 200 records occurs, governor limits are exceeded. What is the most efficient way to refactor this trigger?
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
✓
Collect IDs into a Set and execute a single SOQL query outside the loop.
To avoid SOQL query limits, queries should be moved outside of loops and leverage collections (lists or sets) to retrieve all required data in a single query.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a static variable to cache the query results inside the loop.
Why it's wrong here
Incorrect. Caching inside a loop does not solve the underlying issue of executing queries inside a loop iteration.
- ✓
Collect IDs into a Set and execute a single SOQL query outside the loop.
Why this is correct
Correct. Collecting IDs into a Set and querying once using the IN clause avoids hitting SOQL governor limits.
- ✗
Move the query into a helper method that is called recursively for each record.
Why it's wrong here
Incorrect. This still results in queries being executed multiple times, potentially exceeding limits.
- ✗
Wrap the query in a try-catch block to handle governor limit exceptions.
Why it's wrong here
Incorrect. Governor limit exceptions cannot be caught and handled using try-catch blocks.
About these practice questions
One of 493 original SALESFORCE-PD1 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official Salesforce exam blueprint
This SALESFORCE-PD1 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 SALESFORCE-PD1 exam.