Ultimate access to all questions.
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.