You are managing a BigQuery on-demand environment gcp video
data-engineer-pro video for you are managing a BigQuery on-demand environment for Quantiva Analytics , where the business intelligence (BI) platform executes
Answer
Full Certification Question
You are managing a BigQuery on-demand environment for Quantiva Analytics , where the business intelligence (BI) platform executes hundreds of queries daily. These queries perform aggregations on a large 50 TB fact table containing historical sales data at both daily and monthly levels . The current setup leads to slow query performance and unexpectedly high costs . You want to optimize query response times , reduce cost , and minimize ongoing maintenance . What should you do?