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 questions
Answer options
A: Load only the data that the users is permitted to access
B: Add custom indexes on frequently searched account and contact objects fields Correct answer
C: Limit data loading to the 2000 most recently created records.
D: Create a skinny table to represent account and contact objects.
Correct Answer:
B. Add custom indexes on frequently searched account and contact objects fields
Explanation

With 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.

Why Incorrect

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.

References

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).

Scroll to Top