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 data platform team manages workloads on BigQuery Enterprise edition in the us-central1 region across two separate reservations:
batch_etl: Configured with a baseline of 600 slots, a maximum reservation size of 1,200 slots (allowing up to 600 autoscale slots), and idle slot sharing enabled (ignore_idle_slots = false).reporting_bi: Configured with a baseline of 400 slots, a maximum reservation size of 800 slots (allowing up to 400 autoscale slots), and idle slot sharing enabled (ignore_idle_slots = false).At 03:00 UTC, the reporting_bi reservation is completely idle with 0 active jobs. An unpredicted ETL job begins running in the batch_etl reservation, requiring 1,100 compute slots to process concurrently.
In what order will BigQuery allocate compute capacity to satisfy the 1,100 slot demand, and how will this compute capacity be billed?
batch_etl, immediately autoscales 500 slots to reach the 1,100 slot demand, and leaves reporting_bi untouched; charges include baseline rates for both reservations plus the autoscaling rate for 500 slots.This option describes a scenario where BigQuery triggers dynamic autoscaling immediately after consuming a reservation's local baseline slots, bypassing idle slot sharing entirely.
ignore_idle_slots = false is configured across matching editions and regions.reporting_bi would generate redundant compute charges at the higher autoscaling rate.The batch_etl reservation had idle slot sharing explicitly disabled (ignore_idle_slots = true), preventing it from borrowing unused capacity from reporting_bi.
batch_etl, then borrows 400 idle baseline slots from reporting_bi, and finally autoscales 100 slots; charges include the baseline rates for both reservations plus the autoscaling rate for the 100 scaled slots.BigQuery Editions use a hierarchical slot provisioning mechanism that optimizes performance and cost efficiency across multi-tenant reservation architectures. When jobs demand more compute capacity than a single reservation's baseline, BigQuery allocates capacity according to a strict priority hierarchy: Baseline slots, followed by Idle slot sharing from sibling reservations in the same region and edition, and finally Autoscaling slots up to the reservation's configured maximum size.
batch_etl reservation.ignore_idle_slots is set to false on both reservations within the same edition and region (us-central1), batch_etl borrows the 400 idle baseline slots from the inactive reporting_bi reservation before spinning up autoscaling slots. This brings total available capacity to 1,000 slots.batch_etl.batch_etl) and 400 baseline slots (reporting_bi) at standard baseline/commitment rates, plus the hourly autoscaling rate specifically for the 100 upscaled slots for the duration of the scaling event.reporting_bi, borrowed idle slots are preemptively returned, prompting batch_etl to autoscale further if needed.This allocation sequence minimizes operational expenditure by exhausting already-purchased baseline capacity across the organization before invoking dynamic autoscaling pricing.
reporting_bi, then uses the 600 baseline slots from batch_etl, and autoscales 100 slots; charges include baseline rates for both reservations and on-demand per-TB pricing for the overflow.This option suggests that BigQuery borrows external idle capacity before utilizing local reservation baselines and charges slot overflows via on-demand per-TB pricing.
The project were assigned to the on-demand compute model without edition reservation assignments, where queries are billed strictly based on bytes scanned.
batch_etl up to its maximum ceiling of 1,200 slots before attempting any idle slot sharing; charges include baseline rates plus 600 autoscale slots.This option asserts that a reservation must scale to its maximum autoscaling limit before it can initiate idle slot sharing from peer reservations.
There were no other reservations in the administration project or if all peer reservations were operating at 100% capacity with 0 idle slots available to share.
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