Your organization’s business analysts require near real-time access to streaming data. However, they are reporting that their dashboard queries are loading slowly. After investigating BigQuery query performance, you discover the slow dashboard queries perform several joins and aggregations.
You need to improve the dashboard loading time and ensure that the dashboard data is as up-to-date as possible. What should you do?

A. Disable BigQuery query result caching. B. Modify the schema to use parameterized data types. C. Create a scheduled query to calculate and store intermediate results. D. Create materialized views.