GCP PCA · Question 47 · Manage implementation and optimize costs
Your data analytics team is running complex SQL queries on a 100 TB BigQuery table. The queries are scanning the entire table every time, resulting in massive costs. The queries typically filter data by a transaction_date column and group results by a country_code column. Which TWO BigQuery features should you implement to reduce the amount of data scanned and lower costs? (Select TWO)
Answer options:
Partition the table by transaction_date
Cluster the table by country_code
Change the BigQuery billing model from On-demand to Flat-rate
Export the data to Cloud Storage and query it using external tables
Create a materialized view for every possible country code
50 questions · hints · full answers · grading
Expert