Google Cloud Professional Data Engineer — Question 298

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?

Answer options

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

Correct answer: C

Explanation

The correct answer is C because switching to flat-rate pricing allows you to manage resources more effectively across multiple projects with a hierarchical priority model. This approach helps ensure that your most critical queries receive the necessary resources without hitting the per-project quota. The other options either do not resolve the issue or violate the requirement to avoid adding new projects.