Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
An enterprise is operating BigQuery on the Enterprise edition across several departments. The data engineering team manages a multi-tenant environment with the following workload requirements:
Which configuration strategy should the team implement across their reservations to satisfy these workload requirements while optimizing cost?
ignore_idle_slots = false; create a separate reservation for ad-hoc queries with baseline slots only and set ignore_idle_slots = true.This configuration inverts capacity planning principles by assigning autoscaling and idle borrowing to critical ETL workloads while assigning fixed baseline capacity and strict idle isolation to ad-hoc queries.
Interactive analysts had strict SLAs for fixed queries throughout the day while ETL processes were completely asynchronous and non-critical.
ignore_idle_slots = true; create a separate reservation for ad-hoc queries configured with autoscaling slots and set ignore_idle_slots = false.This strategy uses BigQuery Editions reservation workload management to isolate workloads by defining distinct reservations with customized capacity configurations and idle slot sharing behaviors.
ignore_idle_slots = true ensures that queries in this reservation rely strictly on dedicated capacity, preventing external slot contention or unpredictable performance variations.ignore_idle_slots = false on the ad-hoc analytics reservation permits analyst queries to opportunistically consume unused baseline slots from other reservations in the same administration project, minimizing paid autoscaling events.Separating the workloads into dedicated reservations allows fine-grained control over slot predictability and autoscaling elasticity. Combining baseline guarantees with isolated idle policies provides deterministic execution for ELT while delivering elasticity and cost efficiency for interactive analytics.
ignore_idle_slots = true for all projects across the organization.This approach uses a single shared reservation relying purely on slots autoscaling without any dedicated baseline capacity, while disabling idle slot sharing across the entire organization.
ignore_idle_slots = true globally on a shared pool completely blocks cross-workload slot scavenging, preventing ad-hoc jobs from leveraging unused capacity.All workloads had identical business criticality, non-overlapping execution schedules, and required zero baseline spend commitment.
This option bypasses BigQuery Editions and capacity management entirely, running all workloads under the legacy per-terabyte on-demand analysis model.
Query volumes were extremely low, sporadic, and had no baseline uptime or deterministic performance requirements.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated