Salesforce Certified Data Architecture Practice Test

What is a recommended approach to avoid report time-out issues in Sales Cloud?

1. Create a custom Visualforce report using cached records

2. Replace existing reports with new reports based on Analytics Cloud

3. Create an Apex trigger to prefetch data before the report

4. Create a dashboard that runs reports only once per day

The correct answer is: Replace existing reports with new reports based on Analytics Cloud

Replacing existing reports with new reports based on Analytics Cloud is the recommended approach to avoid report time-out issues in Sales Cloud. This choice leverages the power of Analytics Cloud, which is designed to handle large data sets more efficiently and provide enhanced reporting capabilities. Analytics Cloud uses a different architecture that supports faster data retrieval and more complex aggregations, reducing the likelihood of running into time-out scenarios often encountered with traditional report formats in Sales Cloud. The other options may not address the core issue effectively. For instance, creating a custom Visualforce report might not inherently improve performance and could still face the same time-out constraints as conventional reports. Similarly, using an Apex trigger to prefetch data can lead to unnecessary complexities and doesn't guarantee that report execution will remain efficient. Finally, creating a dashboard that runs reports only once per day may alleviate the immediate issue of time-outs, but it doesn't solve the underlying performance problems associated with large data volumes when users need real-time or frequent access to updates.