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?

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.








 

Suggested Answer: D

Community Answer: D



This question is in Certified Data Architect Exam
For getting Salesforce Certified Data Architect


















Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Salesforce. 
Trademarks, certification & product names are used for reference only and belong to Salesforce.
The website does not contain actual questions and answers from Salesforce's Certification Exams.