Practice Test 3 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
Your company uses BigQuery as its main data warehouse. There are different users with different departments who access BigQuery and run ad-hoc queries. The CTO noticed a hike in BigQuery costs due to running ad-hoc queries scan high volume of data. Hence, she wants to limit the quota for the departments based on their requirements and business needs. How would you achieve this?
A. Allow access to department leads and managers only to control BigQuery access.
B. Set monthly flat-rate pricing for BigQuery.
C. Set custom quotas for each user with access on BigQuery based on their business requirements.
D. Set project-level quotas on BigQuery by setting a fixed size limit to be used monthly.
Correct Answer: C
If you have multiple BigQuery projects and users, you can manage costs by requesting a custom quota that specifies a limit on the amount of query data processed per day.
Creating a custom quota on query data allows you to control costs at the project-level or at the user- level.
• Project-level custom quotas limit the aggregate usage of all users in that project.
• User-level custom quotas are separately applied to each user or service account within a project.
In this scenario, the aim is to control user quotas. So, option C is the best approach.
Option A is incorrect: This is not a sufficient solution to restrict access to management only. This is not the goal of CTO.
Option B is incorrect: Flat-rate can be a possible approach. However, BigQuery does not provide flexible flat-rate pricing and the cheapest is $10,000 for 500 slots, which may not be a desirable option for small to medium businesses.
Option D is incorrect: Setting project-level quota is not the best approach for this scenario because this will not set user limit quotas and when the project reaches the limit set, it will disallow all users to run queries.
Source(s):
BigQuery – Creating custom cost controls:
BigQuery Pricing – Monthly Flat Rate:
Comments are closed, but trackbacks and pingbacks are open.