Free DATA-ARCHITECT Web TestEngine Demo

Q14 Multiple choice

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?

Select all that apply.

A
Ask support to create a skinny table for Application with the necessary reporting fields.
B
Add custom indexes to all fields on Application without a standard index.
C
Run multiple reports to get different pieces of the data and combine them.
D
Add custom indexes to the Date fields used for filtering the report.

DATA-ARCHITECT Web TestEngine demo