Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Google Discussions

Exam Professional Data Engineer topic 1 question 287 discussion

Actual exam question from Google's Professional Data Engineer
Question #: 287
Topic #: 1
[All Professional Data Engineer Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by scaenruy at Jan. 4, 2024, 11:08 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
raaad
Highly Voted 3 months, 3 weeks ago
Selected Answer: C
Reservations guarantee a fixed number of slots (computational resources) for BigQuery queries, ensuring a predictable monthly cost, addressing the marketing team's concern about variability.
upvoted 7 times
AllenChen123
3 months, 2 weeks ago
Why 500 slots?
upvoted 1 times
AllenChen123
3 months, 1 week ago
But seems only C makes sense. https://cloud.google.com/bigquery/quotas#query_jobs "There is no limit to the number of bytes that can be processed by queries in a project."
upvoted 2 times
datapassionate
3 months, 1 week ago
"However, you can set limits on the amount of data users can query by creating custom quotas to control query usage per day or query usage per day per user." https://cloud.google.com/blog/products/data-analytics/manage-bigquery-costs-with-custom-quotas B would be correct
upvoted 1 times
saschak94
2 months, 3 weeks ago
If you use B - the marketing team wouldn't be able to run their queries when the quota is reached, which could harm the business. Having a reservation for 500 slots and no autoscaling gives you exact predictable cost for each month without harming the business or have variable cost with autoscaling So C should be the right answer
upvoted 2 times
...
...
...
...
...
MissK1371
Most Recent 1 week, 5 days ago
Selected Answer: B
at first I thought C for best practices but the questions does not ask to lower the cost just to make the spend consistent
upvoted 2 times
LaxmanTiwari
1 week, 3 days ago
u spot on MissK1371
upvoted 1 times
...
...
BigDataBB
3 weeks, 3 days ago
Selected Answer: B
As wrote @Sofia98 the company using "on-demand billing model", so the best solution should be the B, https://cloud.google.com/blog/products/data-analytics/manage-bigquery-costs-with-custom-quotas
upvoted 1 times
...
ML6
2 months, 2 weeks ago
I agree that at first sight option C seems best. However, the question mentions that they are currently on the on-demand billing model and option C does not mention anything about changing the pricing model from on-demand to capacity computing (BigQuery Standard or Enterprise edition). I don't believe it is possible to reserve slots with on-demand billing.
upvoted 2 times
...
tibuenoc
3 months ago
Selected Answer: D
Option D - https://cloud.google.com/bigquery/pricing Standard Pay-as-you-go Reservation: This model charges only for the slots used, aligning with the marketing team's need for predictable costs. On-demand pricing would lead to variable costs, while committed use discounts or reservations with fixed costs wouldn't provide the needed flexibility. Baseline of 0 Slots: Setting a baseline of 0 ensures no upfront commitment and avoids unused capacity charges if the marketing team's usage is lower than expected. Autoscaling Up to 500 Slots: Autoscaling provides the flexibility to handle unexpected spikes in usage without incurring on-demand pricing costs. The 500-slot limit sets a reasonable upper bound to control spending. Billing Back: Billing the marketing team based on their actual usage promotes cost awareness and encourages responsible resource utilization.
upvoted 2 times
JyoGCP
2 months, 2 weeks ago
Looks like only the baseline slots are guaranteed and immediately available for use where as autoscaling slots are not guaranteed immediately.
upvoted 1 times
JyoGCP
2 months, 2 weeks ago
So C is a better option
upvoted 1 times
JyoGCP
2 months, 2 weeks ago
which will give a consistent bill per month
upvoted 1 times
...
...
...
...
lipa31
3 months, 1 week ago
anybody for D ? https://cloud.google.com/bigquery/docs/slots-autoscaling-intro
upvoted 3 times
...
Sofiia98
3 months, 3 weeks ago
Selected Answer: B
https://cloud.google.com/blog/products/data-analytics/manage-bigquery-costs-with-custom-quotas
upvoted 3 times
...
scaenruy
4 months ago
Selected Answer: C
C. Create a BigQuery reservation with a baseline of 500 slots with no autoscaling for the marketing team, and bill them back accordingly.
upvoted 1 times
Sofiia98
3 months, 3 weeks ago
Provide, please, the reference
upvoted 1 times
...
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel