SQ73
A data team wants to pre-compute expensive aggregations that auto-refresh when base table data changes. Which BigQuery feature supports this?
- AFederated queries
- BMaterialized views
- CExternal tables
- DStandard views only
Show answerHide 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.