
Ultimate access to all questions.
Your company has implemented BigQuery as an enterprise data warehouse solution. Users from various business units frequently run queries against this data warehouse. However, you have observed that the costs associated with running these queries are exceptionally high, necessitating better cost control measures. What are two methods you can use to manage and control these BigQuery query costs effectively? (Choose two.)
A
Split the users from business units to multiple projects.
B
Apply a user- or project-level custom query quota for BigQuery data warehouse.
C
Create separate copies of your BigQuery data warehouse for each business unit.
D
Split your BigQuery data warehouse into multiple data warehouses for each business unit.
E
Change your BigQuery query model from on-demand to flat rate. Apply the appropriate number of slots to each Project.