GCP Professional Data Engineer Practice Question

Creating a dedicated BigQuery capacity reservation for the critical dashboard guarantees that its queries always have the required baseline number of slots. By assigning only the dashboard's service account (or project) to that reservation, the capacity is reserved for the job whenever it runs. When the dashboard is idle, any unused slots automatically flow back to the on-demand pool, where analysts' interactive queries can borrow them at on-demand rates. Changing the dashboard to batch priority would not guarantee a five-minute SLA, and buying a separate reservation for analysts or disabling idle-slot sharing would raise costs and strand capacity. Running the dashboard in another region avoids contention locally but adds data-transfer cost and still provides no slot guarantee.