Skip to content
PCA Practice
SQ73

A data team wants to pre-compute expensive aggregations that auto-refresh when base table data changes. Which BigQuery feature supports this?

  1. AFederated queries
  2. BMaterialized views
  3. CExternal tables
  4. DStandard views only
Show answer

Answer: B

Materialized views store pre-computed results and automatically refresh incrementally when the base table changes, reducing query cost and latency for repeated aggregation patterns.

← SQ72Practice this topicSQ74 →