Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam

Exam Professional Data Engineer topic 1 question 85 discussion

Actual exam question from Google's Professional Data Engineer

Question #: 85
Topic #: 1

[All Professional Data Engineer Questions]

You are a head of BI at a large enterprise company with multiple business units that each have different priorities and budgets. You use on-demand pricing for
BigQuery with a quota of 2K concurrent on-demand slots per project. Users at your organization sometimes don't get slots to execute their query and you need to correct this. You'd like to avoid introducing new projects to your account.
What should you do?

A. Convert your batch BQ queries into interactive BQ queries.
B. Create an additional project to overcome the 2K on-demand per-project quota.
C. Switch to flat-rate pricing and establish a hierarchical priority model for your projects.
D. Increase the amount of concurrent slots per project at the Quotas page at the Cloud Console.

Show Suggested Answer

Suggested Answer: C 🗳️

by sedado77 at Sept. 21, 2022, 6:17 p.m.

Comments

Submit Cancel

sedado77

Highly Voted 1 year, 4 months ago

Selected Answer: C

I got this question on sept 2022. Answer is C

upvoted 8 times

...

grshankar9

Most Recent 6 months, 2 weeks ago

Selected Answer: C

In BigQuery, "on-demand pricing" means you pay based on the amount of data your queries scan (bytes processed), essentially paying for what you use, while "flat-rate pricing" involves purchasing a set number of "slots" (virtual CPUs) and paying a fixed fee regardless of how much data you query, essentially providing a predictable monthly cost for dedicated processing power; on-demand is best for occasional users with variable query needs, while flat-rate is better for predictable high-volume querying

upvoted 1 times

...

email2nn

9 months, 1 week ago

answer us C

upvoted 1 times

...

midgoo

10 months, 2 weeks ago

Selected Answer: C

This question is interesting. My friend works as the TAM in Google and he said we could request for Quota increase if the customer is premium customer instead of changing to Flat-rate Otherwise, need to choose C

upvoted 1 times

...

jin0

11 months, 1 week ago

why A is not a answer? when using interactive bigquery without batch bigquery it lead to run query immediately isn't it? so it seems to solve the problems isn't it?

upvoted 1 times

...

samdhimal

1 year ago

C. Switch to flat-rate pricing and establish a hierarchical priority model for your projects.

upvoted 3 times

samdhimal

1 year ago

Switching to flat-rate pricing would allow you to ensure a consistent level of service and avoid running into the on-demand slot quota per project. Additionally, by establishing a hierarchical priority model for your projects, you could allocate resources based on the specific needs and priorities of each business unit, ensuring that the most critical queries are executed first. This approach would allow you to balance the needs of each business unit while maximizing the use of your BigQuery resources.

upvoted 4 times

...

zellck

1 year, 1 month ago

Selected Answer: C

C is the answer. https://cloud.google.com/bigquery/docs/reservations-intro The benefits of using BigQuery Reservations include: - Workload management. After you purchase slots, you can allocate them to workloads. That way, a workload has a dedicated pool of BigQuery computational resources available for use. At the same time, if a workload doesn't use all of its allocated slots, any unused slots are shared automatically across your other workloads. - Centralized purchasing: You can purchase and allocate slots for your entire organization. You don't need to purchase slots for each project that uses BigQuery.

upvoted 2 times

...

hybridpro

1 year, 2 months ago

C. https://cloud.google.com/bigquery/quotas - 2000 is the max no. of slots

upvoted 1 times

...