Salesforce Certified Data Architect — Question 37

A large retail company has recently chosen Salesforce as Its CRM solution. They have the following record counts:
2,500,000 Accounts
25,000,000 Contacts
When doing an initial performance test, the data architect noticed an extremely slow response-time for reports and list views.
What should a data architect do to solve the performance issues?

Answer options

• A. Create a Skinny Table to represent Account and Contact objects.
• B. Limit data loading to the 2,000 most recently created records.
• C. Add Custom Indexes on frequently searched Account and Contact fields.
• D. Load only data that the user is permitted to access.

Correct answer: C

Explanation

The correct answer is C because adding custom indexes on frequently searched fields can significantly improve query performance, allowing for faster access to data. Options A and B do not directly address the underlying performance issues related to search queries, while option D, although important for security, does not resolve performance concerns for the reporting and list views.