Google Cloud Professional Data Engineer — Question 205

You are administering shared BigQuery datasets that contain views used by multiple teams in your organization. The marketing team is concerned about the variability of their monthly BigQuery analytics spend using the on-demand billing model. You need to help the marketing team establish a consistent BigQuery analytics spend each month. What should you do?

Answer options

• 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.

Correct answer: C

Explanation

The correct choice is C because creating a BigQuery reservation with a baseline of 500 slots ensures that the marketing team has guaranteed resources, leading to predictable costs. Options A and D involve autoscaling, which can lead to variability in costs, while option B does not provide the necessary reservation of slots to ensure consistent spending.