DATA-ARCHITECT practice question 16 of 35
A large retail company has recently chosen SF as its CRM solution. They have the following record counts: 2500000 accounts 25000000 contacts When doing an initial performance test, the data architect noticed an extremely slow response for reports and list views. What should a data architect do to solve the performance issue?
Full set: 257 questionsWith large data volumes (2.5M accounts, 25M contacts), reports and list views become slow because the database must scan a massive number of records to find the requested data. Adding custom indexes on fields that are frequently used for filtering, sorting, or querying in reports and list views is a primary performance tuning strategy. An index acts like a lookup table, allowing the database to locate the relevant records much more efficiently, directly addressing the slow response times.
A. Loading only data users can access relates to the sharing model, not the underlying query performance on the full dataset. The query is still slow.
C. This avoids the problem by not loading the required data, which is not a viable business solution for a CRM that needs a complete customer view.
D. A skinny table is a valid solution for report performance, but indexing is a more fundamental and often first-line approach to optimize queries on specific fields.
1. Salesforce Architects. (2022). Architect's Guide to Large Data Volumes. Salesforce. Page 14, "Query and Search Optimization," states, "The Salesforce query optimizer can use indexes on standard and custom fields to speed up queries."
2. Salesforce Help. (2023). Best Practices for Deployments with Large Data Volumes. "Custom Indexes," section. "To improve performance of queries, reports, and list views, ask Salesforce to create indexes on fields that are filtered on."
3. Gessner, G. H., & Schiefer, J. (2012). Database Performance Tuning and Optimization. In: Encyclopedia of Database Systems. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-39940-9108 (This academic source explains the fundamental principle of using indexes to optimize database query performance, which is the core concept here).
Keep practicing
Take the free DATA-ARCHITECT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATA-ARCHITECT practice questions
- Question 1Which three characteristics of a skinny table help improve report and query performance?
- Question 2Universal Containers (UC) has built a custom application on Salesforce to help track ship…
- Question 3Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not …
- Question 4Universal Container (UC) has accumulated data over years and has never deleted data from …
- Question 5Universals Containers’ system administrators have been complaining that they are not able…
- Question 6Universal Containers is experiencing frequent and persistent group membership locking iss…
