Service-Con-201 Service Cloud Solution Design Practice Question
An organization has millions of cases and experiences degraded report performance when running weekly case volume summaries. The database administrator recommends optimizing query performance without deleting historical records. Which declarative feature should be evaluated?
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
✓
Request Skinny Tables or custom indexes through Salesforce Support
Custom Indexes and Skinny Tables (enabled via Salesforce Support) optimize SOQL and reporting performance for large data volumes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Convert all Case reports to joined reports with zero common blocks
Why it's wrong here
Joined reports do not solve underlying database indexing or table join performance bottlenecks.
- ✗
Enable Platform Cache partitions for Case reports
Why it's wrong here
Platform Cache stores session/application transactional data in memory, not underlying database report query execution tables.
- ✗
Export half the data to CSV and delete it from the primary database daily
Why it's wrong here
Deleting core data destroys historical reporting context.
- ✓
Request Skinny Tables or custom indexes through Salesforce Support
Why this is correct
Skinny tables combine frequently used fields and bypass joins, drastically improving report and query performance for large datasets.
About these practice questions
Courseiva writes every Service-Con-201 question from scratch — 318 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 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 Service-Con-201 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 Service-Con-201 exam.