ExpertGCP 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)
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
How to approach this question
Full Answer
Common mistakes
Practice the full GCP Professional Cloud Architect Practice Exam 6
50 questions · hints · full answers · grading