You need predictable BigQuery capacity for critical workloads. What do you use?
Why D is the answer
BigQuery Editions and reservations
BigQuery Editions and reservations set aside capacity for critical workloads.
In detail
- Editions and reservations give predictable capacity.
- Reservations set aside slots.
Use case
An illustrative scenario, not a real incident.
A critical workload needs steady capacity, so a team buys reservations through BigQuery Editions.
See it in different ways
stateDiagram-v2 [*] --> QueryPlan QueryPlan --> PartitionAndCluster: scans too much QueryPlan --> MaterializedView: repeated aggregation QueryPlan --> BiEngine: dashboards need sub-second PartitionAndCluster --> [*] MaterializedView --> [*] BiEngine --> [*]
flowchart TD
Q{"Is capacity critical?"}
Q -->|"Yes"| A0["Reservations"]
Q -->|"No"| A1["On demand"]Key point: Reservations give predictable capacity.
Why the other options are wrong
- A. BI Engine alone
- BI Engine speeds up dashboards, and does not reserve slots.
- B. A Pub/Sub dead-letter topic
- That handles failed messages.
- C. A new Dataform repository
- That manages SQL code.