Exit DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER Salesforce Certified Data Architecture and Management Designer
Question 2 of 5
0% complete
Q2 Single choice

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 time-outs.

What is the fastest and most effective way for a data architect to solve the time-out issue?

  • A

    Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.

  • B

    Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.

  • C

    Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

  • D

    Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on it.

Previous Next