SNOW-CSA UI, Navigation and Forms Practice Question
A performance issue is reported on the Change Request list view: it takes several seconds to load. The list has 5000 records and uses several calculated fields. Which optimization should be applied first?
⚠ Common exam trap
It's easy for candidates to assume increasing the list threshold or using aggregation will solve performance issues, but they fail to recognize that calculated fields are the primary performance drain and that reducing columns is the simplest and most effective first step.
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
✓
Create a new list view that includes only essential columns
Reducing the number of columns in a list view minimizes the data retrieved per row, directly addressing the performance bottleneck caused by calculated fields. Calculated fields are evaluated for every row on every load, so removing unnecessary columns reduces server-side computation and database query overhead. This is the most effective first optimization as it targets the root cause without increasing data volume or altering system thresholds.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Add a group by condition on the list view
Why it's wrong here
Grouping adds database overhead.
- ✗
Set the list control to 'Auto' to reduce data threshold
Why it's wrong here
Auto mode reduces page size but still loads all columns.
- ✗
Increase the 'glide.ui.list.threshold' system property to 10000
Why it's wrong here
This would load more records, worsening performance.
- ✓
Create a new list view that includes only essential columns
Why this is correct
Fewer columns reduces data load and improves performance.
Go deeper
Related to this question
About these practice questions
Courseiva writes every SNOW-CSA question from scratch — 504 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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 SNOW-CSA practice question is part of Courseiva's free ServiceNow 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 SNOW-CSA exam.