Bigquery Reservation Concurrency Autoscaling Monitoring

Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.

An analytics team is running interactive dashboard queries in BigQuery using an Enterprise Edition reservation configured with baseline slots and autoscaling capacity. During peak reporting hours, numerous concurrent queries execute simultaneously, diluting the slot allocation per query and causing unacceptable latency. Additionally, finance reports discrepancies between query-level slot runtime metrics and compute reservation charges.

Which combination of configuration and observability practices should the data engineering team implement to stabilize query performance and correctly analyze compute costs?

Assign all queries to run as batch query jobs rather than interactive jobs, and use INFORMATION_SCHEMA.RECOMMENDATIONS to verify monthly slot reductions.

Set default_interactive_query_queue_timeout_ms to -1 in INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS, and increase baseline slots to match peak concurrency demand.

Set a non-zero target_job_concurrency on the reservation using ALTER RESERVATION, and monitor autoscaling capacity costs through reservation-level capacity compute metrics rather than aggregating slot-milliseconds from INFORMATION_SCHEMA.JOBS.

Configure ignore_idle_slots to true on the reservation, and calculate compute billing by aggregating total_slot_ms from INFORMATION_SCHEMA.JOBS grouped by reservation_id.

Professional Cloud Data Engineer

Bigquery Reservation Concurrency Autoscaling Monitoring

Related questions