Which BigQuery feature precomputes results for repeat queries?
Why B is the answer
Materialized views
Materialized views store precomputed results.
In detail
- Materialized views precompute results.
- Good for repeated patterns.
Use case
An illustrative scenario, not a real incident.
A heavy aggregation repeats all day, and a materialized view answers most of those queries.
See it in different ways
flowchart LR A["Base tables"] --> B["Materialized view"] B --> C["BI Engine"] C --> D["Fast dashboard"]
stateDiagram-v2 [*] --> QueryPlan QueryPlan --> PartitionAndCluster: scans too much QueryPlan --> MaterializedView: repeated aggregation QueryPlan --> BiEngine: dashboards need sub-second PartitionAndCluster --> [*] MaterializedView --> [*] BiEngine --> [*]
flowchart TD
Q{"Does a query repeat often?"}
Q -->|"Yes"| A0["Materialized view"]
Q -->|"No"| A1["Run it as it is"]Key point: Materialized views precompute repeat queries.
Why the other options are wrong
- A. Dataproc autoscaling
- Autoscaling is about clusters.
- C. Airflow sensors
- Sensors wait for conditions.
- D. Pub/Sub ordering keys
- Ordering keys are about messages.