Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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.