Associate Data Practitioner

By Google · Question Mode

QuestionQ10

Data Management

The organization’s business analysts need near-real-time access to streaming data, but report that dashboard queries load slowly. Investigation of BigQuery query performance shows that the slow dashboard queries execute several joins and aggregations.

You need to improve dashboard load time while ensuring the dashboard data is as up to date as possible. What should you do?

Explanation

BigQuery materialized views precompute query results, reducing the work required for repeated dashboard joins and aggregations. They are automatically refreshed as base-table data changes and can use base-table changes to produce up-to-date results, making them appropriate for low-latency dashboards over streaming data.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!