GCP PCA · Question 46 · Technical Requirements
Your data analytics team runs queries against a 100 TB BigQuery table containing 5 years of sales data. Most queries filter by the 'transaction_date' and group by 'store_id'. The queries are currently scanning the entire table, resulting in high costs and slow performance. Which TWO optimizations should you apply? (Select TWO)
Answer options:
Partition the table by 'transaction_date'
Cluster the table by 'store_id'
Export the data to Cloud Storage and query it using external tables
Change the BigQuery pricing model to flat-rate
Create a separate BigQuery dataset for each store
50 questions · hints · full answers · grading
Expert