Valid Data-Architecture-And-Management-Designer Dumps shared by ExamDiscuss.com for Helping Passing Data-Architecture-And-Management-Designer Exam! ExamDiscuss.com now offer the newest Data-Architecture-And-Management-Designer exam dumps, the ExamDiscuss.com Data-Architecture-And-Management-Designer exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com Data-Architecture-And-Management-Designer dumps with Test Engine here:
Access Data-Architecture-And-Management-Designer Dumps Premium Version
(224 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 42/78
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?
Which solution should a data architect recommend to improve reporting performance?
Recent Comments (The most recent comments are at the top.)
The most accurate answer is D. Contact Salesforce support to enable skinny table for cases.
Skinny tables can help improve the performance of reports and list views in Salesforce. They contain frequently used fields and are kept in sync with their source tables. By reducing the number of joins performed during a query, skinny tables can significantly improve the performance of reports and list views.
Not A. Create a custom object to store aggregate data and run reports: While this could potentially improve performance, it would require additional configuration and maintenance. It also doesn’t address the underlying issue of having a large number of case records
Enabling Skinny Tables indeed. It's standard protocol in this situation and ST's are not activated out-of-the-box. So you have to ask Customer support to help. Enabling skinny tables can significantly improve reporting performance in Salesforce. Skinny tables are a feature that allows you to denormalize data by creating a separate, optimized table for frequently used or complex reports. This table contains a subset of the fields from the original object, resulting in faster query execution times.
https://developer.salesforce.com/docs/atlas.en-us.salesforce_large_data_volumes_bp.meta/salesforce_large_data_volumes_bp/ldv_deployments_infrastructure_skinny_tables.htm
"Contact Salesforce support to enable skinny table for cases." should be the correct answer