Topic 1 Question 96
2 つ選択Your company implemented BigQuery as an enterprise data warehouse. Users from multiple business units run queries on this data warehouse. However, you notice that query costs for BigQuery are very high, and you need to control costs. Which two methods should you use?
Split the users from business units to multiple projects.
Apply a user- or project-level custom query quota for BigQuery data warehouse.
Create separate copies of your BigQuery data warehouse for each business unit.
Split your BigQuery data warehouse into multiple data warehouses for each business unit.
Change your BigQuery query model from on-demand to flat rate. Apply the appropriate number of slots to each Project.
ユーザの投票
コメント(17)
I'd say B and E. So either you do B or E to reduce costs.
👍 41CPBach2020/06/28B & E Refer below link - first of all you can define quotas on project or user level and 2nd one is you can change from on demand to flat rate model and define the parameters based on your requirement ---
https://cloud.google.com/bigquery/docs/custom-quotas https://cloud.google.com/bigquery/pricing#flat_rate_pricing
👍 21Jignesh_Gamdha2020/11/02- 正解だと思う選択肢: BE
The two methods that should be used to control BigQuery query costs are:
B. Apply a user- or project-level custom query quota for BigQuery data warehouse: Setting a custom query quota will limit the amount of data a user or project can query within a given period, which helps in controlling costs.
E. Change your BigQuery query model from on-demand to flat rate. Apply the appropriate number of slots to each Project: With a flat-rate pricing model, the user pays a fixed monthly fee based on the number of slots used. This enables better cost control and also ensures better query performance as the slots are reserved for the user's exclusive use.
Answers A, C, and D are not recommended as they would require a lot of effort and maintenance for managing multiple projects or data warehouses.
👍 2Buruguduystunstugudunstuy2023/02/23
シャッフルモード