Answer-first summary for fast verification
Answer: Create two reservations, one for each of the projects. For the SLA project, use an Enterprise Edition with a baseline of 300 slots and enable autoscaling up to 500 slots. For the ad-hoc project, configure on-demand billing.
The correct answer is B. For the SLA project, an Enterprise Edition reservation with a baseline of 300 slots and autoscaling up to 500 slots will ensure that the required compute resources are available during peak loads, meeting the strict completion time SLAs. For the ad-hoc project, configuring on-demand billing is appropriate because these queries generally do not exceed 200 slots and need to be billed based on the amount of data scanned. This setup ensures that both projects have the appropriate compute resources and billing model.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are managing two projects that involve running BigQuery jobs:
The first project focuses on production jobs with strict completion time SLAs. These high priority jobs require adequate compute resources and typically utilize no less than 300 slots, though they can occasionally see spikes needing up to an additional 500 slots.
The second project is designated for users to execute ad-hoc analytical queries. This project usually does not exceed a usage of 200 slots at any given time. Here, you prefer that the ad-hoc queries be billed based on the volume of data scanned rather than slot capacity.
You need to ensure that both projects are allocated the appropriate compute resources. What actions should you take to achieve this?
A
Create a single Enterprise Edition reservation for both projects. Set a baseline of 300 slots. Enable autoscaling up to 700 slots.
B
Create two reservations, one for each of the projects. For the SLA project, use an Enterprise Edition with a baseline of 300 slots and enable autoscaling up to 500 slots. For the ad-hoc project, configure on-demand billing.
C
Create two Enterprise Edition reservations, one for each of the projects. For the SLA project, set a baseline of 300 slots and enable autoscaling up to 500 slots. For the ad-hoc project, set a reservation baseline of 0 slots and set the ignore idle slots flag to False.
D
Create two Enterprise Edition reservations, one for each of the projects. For the SLA project, set a baseline of 800 slots. For the ad-hoc project, enable autoscaling up to 200 slots.