SQ51
A company reserves 100 slots for BigQuery but only uses 60 on average, with peaks of 150. Which approach best balances cost and performance?
- ADisable reservation and use a spreadsheet
- BReserve 200 to cover peaks
- CSwitch entirely to on-demand
- DKeep 100 reserved and add autoscaling for burst capacity
Show answerHide answer
Answer: D
Baseline reservations for steady-state usage combined with autoscaling slots for peak demand provides the best cost-performance balance. Over-reserving wastes money. Pure on-demand is expensive at this scale.