Skip to content
PCA Practice
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?

  1. ADisable reservation and use a spreadsheet
  2. BReserve 200 to cover peaks
  3. CSwitch entirely to on-demand
  4. DKeep 100 reserved and add autoscaling for burst capacity
Show 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.

← SQ50Practice this topicSQ52 →