Dashboards need sub-second BigQuery results. Which feature helps?
Why D is the answer
BI Engine
BI Engine is an in-memory analysis service.
In detail
- BI Engine gives sub-second dashboard results.
- It suits BI workloads.
Use case
An illustrative scenario, not a real incident.
A dashboard must feel instant, and BI Engine serves results from memory.
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 LR S0["Dashboard query"] --> S1["BI Engine"] --> S2["Sub-second result"]
Key point: BI Engine accelerates with memory.
Why the other options are wrong
- A. Transfer Appliance
- That moves data.
- B. Datastream
- That replicates data.
- C. Managed Service for Apache Airflow
- That runs workflows.