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

Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam
Go to Exam

Exam Professional Data Engineer topic 1 question 260 discussion

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

You have two projects where you run BigQuery jobs:
• One project runs production jobs that have strict completion time SLAs. These are high priority jobs that must have the required compute resources available when needed. These jobs generally never go below a 300 slot utilization, but occasionally spike up an additional 500 slots.
• The other project is for users to run ad-hoc analytical queries. This project generally never uses more than 200 slots at a time. You want these ad-hoc queries to be billed based on how much data users scan rather than by slot capacity.

You need to ensure that both projects have the appropriate compute resources available. What should you do?

  • A. Create a single Enterprise Edition reservation for both projects. Set a baseline of 300 slots. Enable autoscaling up to 700 slots.
  • B. Create two reservations, one for each of the projects. For the SLA project, use an Enterprise Edition with a baseline of 300 slots and enable autoscaling up to 500 slots. For the ad-hoc project, configure on-demand billing.
  • C. Create two Enterprise Edition reservations, one for each of the projects. For the SLA project, set a baseline of 300 slots and enable autoscaling up to 500 slots. For the ad-hoc project, set a reservation baseline of 0 slots and set the ignore idle slots flag to False.
  • D. Create two Enterprise Edition reservations, one for each of the projects. For the SLA project, set a baseline of 800 slots. For the ad-hoc project, enable autoscaling up to 200 slots.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by scaenruy at Jan. 3, 2024, 5:29 p.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 10 months, 3 weeks ago
Selected Answer: B
- The SLA project gets a dedicated reservation with autoscaling to handle spikes, ensuring it meets its strict completion time SLAs. - The ad-hoc project uses on-demand billing, which means it will be billed based on the amount of data scanned rather than slot capacity, fitting the billing preference for ad-hoc queries.
upvoted 7 times
ce9e395
8 months, 2 weeks ago
Critical jobs can spike up to 800 slots, making option B wrong
upvoted 2 times
barrru
8 months, 1 week ago
in this context, "enable autoscaling up to 500 slots" means that the system can add up to 500 slots beyond the baseline
upvoted 2 times
chrissamharris
8 months ago
I dont think thats correct. "up to 500 slots" means the maximum limit is 500 slots - it doesnt specify autoscaling an additional 500 slots.
upvoted 1 times
...
...
...
...
ToiToi
Most Recent 3 weeks, 1 day ago
Selected Answer: B
100% B I work with BQ on a daily basis, did the transition from falt rate to editions last year, have been configuring this for so many customers. Billing for data analysed rather than slots is on demand - so no other option other than B makes sense.
upvoted 1 times
...
SamuelTsch
3 weeks, 2 days ago
Selected Answer: B
https://cloud.google.com/bigquery/docs/slots-autoscaling-intro#using_reservations_with_baseline_and_autoscaling_slots says clearly, "Autoscaling slots are only added after all of the baseline slots (and idle slots if applicable) are consumed."
upvoted 1 times
...
CGS22
7 months, 2 weeks ago
Selected Answer: B
Separate Reservations: This approach provides tailored resource allocation and billing models to match the distinct needs of each project. SLA Project Reservation: Enterprise Edition: Guarantees consistent slot availability for your production jobs. Baseline of 300 slots: Ensures resources are always available to meet your core usage at a predictable cost. Autoscaling up to 500 slots: Accommodates bursts in workload while controlling costs. Ad-hoc Project On-demand: On-demand billing: Charges based on data scanned, ideal for unpredictable and variable query patterns by your ad-hoc users.
upvoted 2 times
...
chrissamharris
8 months ago
Selected Answer: D
Note, Option A states autoscale "up to" (not an additional) 500 slots, whereas the requirement is 800 slots. Making option D the only viable option.
upvoted 1 times
ToiToi
3 weeks, 1 day ago
"You want these ad-hoc queries to be billed based on how much data users scan rather than by slot capacity." this is the only thing you need to read out of the question. Having spikes of 500 slots does not mean you should set a baseline of 800, it is WAY too expensive to do that for spikes.
upvoted 1 times
...
chrissamharris
8 months ago
Scratch this - Option B: https://cloud.google.com/bigquery/docs/slots-autoscaling-intro#using_reservations_with_baseline_and_autoscaling_slots Baseline Slots and AutoScaling Slots are treated as two different entities in the documentation. Therefore B is right despite the horrific wording of the answers.
upvoted 3 times
...
...
potatoKiller
8 months ago
"You want these ad-hoc queries to be billed based on how much data users scan rather than by slot capacity." So D is out. Choose B
upvoted 3 times
...
barrru
8 months, 1 week ago
B "enable autoscaling up to 500 slots" means that the system can add up to 500 slots beyond the baseline as needed, effectively allowing for a total of 800 slots (300 baseline + 500 autoscaled) during peak usage.
upvoted 3 times
...
hanoverquay
8 months, 1 week ago
Selected Answer: D
500 (additional) +300 = 800, so answer is D
upvoted 1 times
...
JyoGCP
9 months, 1 week ago
Selected Answer: B
Option B. Not D because "In Project-2, ad-hoc queries need to be billed based on how much data users scan rather than by slot capacity."
upvoted 4 times
...
danisxp
10 months, 1 week ago
Selected Answer: D
Considering the emphasis on strict completion time SLA's.I go with option D. However I think both B and D are not the best solution here.
upvoted 1 times
...
Matt_108
10 months, 2 weeks ago
Selected Answer: B
Option B - first project works well with dedicated reservation and autoscaling. The second one requires on demand billing, as per question requires.
upvoted 2 times
...
ElenaL
10 months, 2 weeks ago
Selected Answer: D
"These jobs generally never go below a 300 slot utilization, but occasionally spike up an additional 500 slots." -> if it spikes up an ADITIONAL 500 slots, on top of the regular 300, shouldn't we reserve at a minimum 800? open to explanations as to why this is not the case.
upvoted 3 times
...
scaenruy
10 months, 3 weeks ago
Selected Answer: B
B. Create two reservations, one for each of the projects. For the SLA project, use an Enterprise Edition with a baseline of 300 slots and enable autoscaling up to 500 slots. For the ad-hoc project, configure on-demand billing.
upvoted 2 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