Salesforce Certified Data Architect — Question 10

Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting performance Issues and time-outs while running case reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?

Answer options

• A. Contact Salesforce support to enable skinny table for cases.
• B. Build reports using custom Lightning components.
• C. Create a custom object to store aggregate data and run reports.
• D. Move data off of the platform and run reporting outside Salesforce, and give access to reports.

Correct answer: A

Explanation

The correct answer is A because enabling skinny tables can significantly reduce the number of fields that need to be processed during report generation, thereby improving performance. Options B and C may not directly address the underlying performance issues with large datasets, while option D would complicate access and management of the data.