Answer-first summary for fast verification
Answer: Create a BigQuery reservation with a baseline of 500 slots with no autoscaling for the marketing team, and bill them back accordingly.
The marketing team is concerned about the variability in their BigQuery analytics spend. To address this, the best approach is to create a BigQuery reservation with a fixed number of slots without autoscaling. This ensures a predictable and consistent cost each month since the cost is based on reserved slots. Autoscaling introduces variability, which contradicts the goal of consistent spending. Therefore, the correct answer is option C.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As an administrator of shared BigQuery datasets that encompass views utilized by multiple teams within your organization, you encounter a concern from the marketing team regarding the unpredictable nature of their monthly BigQuery analytics expenditures under the on-demand billing model. To address this issue, the marketing team seeks to achieve a steadier and more predictable BigQuery analytics spending each month. What approach should you take to assist the marketing team in establishing a consistent monthly BigQuery analytics spend?
A
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.
B
Establish a BigQuery quota for the marketing team, and limit the maximum number of bytes scanned each day.
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 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.
No comments yet.