Exam Data-Architect Topic 7 Question 179 Discussion

Creating an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports (option D) is the fastest and most effective way for a data architect to solve the time-out issue, as it reduces the amount of data that needs to be queried and processed by the reports. Creating custom fields on opportunity and copying data from order into those custom fields (option A) is not a good solution, as it may create data redundancy and inconsistency, and it does not address the large volume of data. Extracting opportunity and order data from Salesforce and using a third-party reporting tool (option B) is also not a good solution, as it may introduce additional complexity and cost, and it does not leverage the native reporting features of Salesforce. Creating a skinny table in Salesforce and copying order and opportunity fields into it (option C) is also not a good solution, as it may not support all the reporting requirements, and it does not reduce the number of records.