Google Cloud Associate Data Practitioner — Question 23

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?

Answer options

• 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.

Correct answer: D

Explanation

Creating materialized views is the correct solution because they store precomputed results of complex queries, which can significantly speed up dashboard loading times by avoiding repetitive calculations. Disabling query result caching (Option A) may actually increase loading times, while modifying the schema (Option B) and creating scheduled queries (Option C) do not directly address the need for faster access to frequently updated data.