Explanation:
The correct answer is C. By setting up a BigQuery reservation with a baseline of 500 slots for the marketing team, you ensure they have dedicated capacity at all times, leading to a consistent monthly spend. Disabling autoscaling prevents unexpected cost spikes. Billing them based on reserved capacity ensures predictable charges.
Ultimate access to all questions.
No comments yet.
As the administrator of shared BigQuery datasets that include views used by various teams in your organization, the marketing team has raised concerns about unpredictable monthly BigQuery analytics costs under the on-demand billing model. What strategy can you implement to help the marketing team achieve a consistent monthly BigQuery analytics expenditure?
A
Establish a BigQuery quota for the marketing team, limiting the maximum number of bytes scanned each day.
B
Create a BigQuery Standard pay-as-you-go reservation with a baseline of 0 slots and autoscaling set to 500 for the marketing team, and bill them back accordingly.
C
Create a BigQuery reservation with a baseline of 500 slots with no autoscaling for the marketing team, and bill them back accordingly.
D
Create a BigQuery Enterprise reservation with a baseline of 250 slots and autoscaling set to 500 for the marketing team, and bill them back accordingly.