Exam Data-Architect Topic 6 Question 172 Discussion

Actual exam question for Salesforce's Data-Architect exam
Question #: 172
Topic #: 6
Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters. Which two options can be used to improve report performance?

Suggested Answer: A,D Vote an answer

Ask support to create a skinny table for Application with the necessary reporting fields. This is an option that can improve report performance by creating a custom table that contains frequently used fields and copies their values from standard or custom objects. Skinny tables are kept in sync with their source tables and are used in place of them for reports and queries4. Add custom indexes to the Date fields used for filtering the report. This is another option that can improve report performance by creating custom indexes on fields that are often used as filters or join conditions in reports and queries. Custom indexes can speed up data retrieval and reduce query execution time

by Nigel at Jan 28, 2024, 11:00 PM

Limited Time Offer

15%

Off

Get Premium Data-Architect Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
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.
0
0
0
10