An executive dashboard powered by watsonx.data Presto shows slow load times due to expensive aggregate queries. What is the most effective architectural solution?

Pre-aggregating KPIs into Gold-layer summary tables (materialized or scheduled) means the dashboard reads from small pre-computed tables rather than scanning millions of rows; dramatically improving dashboard load times. The incorrect options ("Increase the executive users' IAM permissions to allow them to access larger engines", "Disable row-level security so the queries run faster without policy checks", "Convert the dashboard to use Python scripts instead of SQL queries") are distractors that don't fully capture the concept described.