Google Professional Data Engineer
Get started today
Ultimate access to all questions.
You are managing two BigQuery projects with distinct requirements: one for production jobs with strict SLAs needing high priority and consistent access to 300 slots (spiking to 800), and another for ad-hoc analytical queries preferring billing based on data scanned, typically using up to 200 slots. How should you allocate compute resources to meet both projects' needs?
You are managing two BigQuery projects with distinct requirements: one for production jobs with strict SLAs needing high priority and consistent access to 300 slots (spiking to 800), and another for ad-hoc analytical queries preferring billing based on data scanned, typically using up to 200 slots. How should you allocate compute resources to meet both projects' needs?
Real Exam
A
Establish two Enterprise Edition reservations, one for each project. 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 disable the ignore idle slots flag.
0.0%
B
Create a single Enterprise Edition reservation for both projects with a baseline of 300 slots and enable autoscaling up to 700 slots.
Comments
Loading comments...