Question

Your company runs two BigQuery Enterprise edition reservations: 'prod-etl' (500 baseline slots, autoscale to 1000) for nightly transformation jobs, and 'adhoc-analytics' (200 baseline slots, no autoscale) for data scientists' interactive queries. During business hours, the ETL reservation sits mostly idle, while analysts frequently complain that their queries queue for minutes waiting for slots. Management wants analyst query latency reduced without increasing total committed spend. What should you do?

Accepted Answer

Enable slot sharing by leaving 'ignore idle slots' unset (default) on the 'prod-etl' reservation so its idle slots become available to the 'adhoc-analytics' reservation.

Answer

Increase the 'adhoc-analytics' baseline to 700 slots and reduce 'prod-etl' baseline to 0, relying entirely on autoscaling for ETL.

Answer

Move the 'adhoc-analytics' workload to on-demand billing so it is never constrained by reserved slots.

Answer

Set the 'adhoc-analytics' reservation's max autoscale slots to 1000 to match the ETL reservation.