Exam Professional Data Engineer topic 1 question 85 discussion

I got this question on sept 2022. Answer is 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

answer us 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

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?

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

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.

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