GCP Professional Data Engineer Practice Question

A one-year slot commitment provides the lowest unit cost when the same capacity is required every workday. Create a reservation that holds the 1,000 committed slots and assign only the prod-analytics project to it. Then create a second reservation that owns 0 slots and assign the other projects to that reservation. BigQuery automatically lets the 0-slot reservation borrow any idle slots from the 1,000-slot reservation, but when the dashboard starts, the full 1,000 slots are immediately reclaimed for prod-analytics, ensuring its performance target. Flex slots are more expensive per hour and would require daily provisioning, while upgrading editions or lowering query priority would not reserve capacity and therefore cannot guarantee the required latency.