Salesforce Certified Data Architect — Question 62

Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.
What is the fastest and most effective way for a data architect to solve the time-out issue?

Answer options

• A. Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on it.
• B. Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.
• C. Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.
• D. Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

Correct answer: D

Explanation

The correct answer is D because creating an aggregate custom object allows for summarization of data, reducing the load and time required to generate reports. Options A, B, and C do not directly address the timeout issue effectively, as they either complicate data retrieval, involve external tools, or require inefficient modifications to existing objects.