ExamTopics Logo
Mail Us[email protected]
Menu
Salesforce Discussions
exam questions

Exam Certified Data Architect All Questions

View all questions & answers for the Certified Data Architect exam
Go to Exam

Exam Certified Data Architect topic 1 question 2 discussion

Actual exam question from Salesforce's Certified Data Architect
Question #: 2
Topic #: 1
[All Certified Data Architect Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by BorisBoris at June 24, 2023, 9:04 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
BorisBoris
Highly Voted 1 year, 7 months ago
Answer A. Skinny tables can be beneficial for improving reporting performance in Salesforce, especially when dealing with large volumes of data and complex queries. By enabling skinny tables for the Case object, Salesforce creates denormalized copies of the data, which can significantly speed up query execution times and enhance overall performance.
upvoted 9 times
...
Maya_B
Most Recent 8 months, 2 weeks ago
Selected Answer: A
Skinny tables are the fittest to counter reporting performance issues. Moving data off of the platform could have been a solution but it is less efficient than skinny tables for the problem displayed. 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
upvoted 2 times
...
lizbette
10 months ago
Selected Answer: A
A - Skinny Tables, which are compatible with up to 100 fields, of a certain type
upvoted 2 times
...
tobicky
1 year, 3 months ago
Selected Answer: A
The most accurate answer is A. 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
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel