Question

Your company runs on-demand BigQuery for most of its ad hoc analytics, but every month-end there is a 3-day period where the finance team executes very heavy scheduled batch reports, causing costs to spike unpredictably and occasionally hitting on-demand concurrency limits. Outside of month-end, query volume is low and steady. Management wants predictable, minimized cost for the month-end workload without over-committing capacity for the rest of the month. What should you do?

Accepted Answer

Create a reservation using flex slot commitments (short-term/autoscaling) that you activate for the 3-day month-end window, and assign the finance batch jobs to it while keeping other analytics on on-demand.

Answer

Purchase an annual slot commitment sized for the month-end peak and route all workloads through the reservation.

Answer

Increase the on-demand per-project concurrency quota and leave all workloads on on-demand pricing.

Answer

Purchase a monthly flat-rate commitment for the peak capacity and keep it for the entire month.