GCP PCA · Question 38 · Domain 1: Designing and Planning a Cloud Solution Architecture
Your data analysts are running expensive queries on a 100TB BigQuery table containing 5 years of daily sales data. They usually only query the last 30 days. Which TWO optimizations should you apply? (Select TWO)
Answer options:
Partition the table by date.
Cluster the table by date.
Require a partition filter on all queries.
Export the data to Cloud Storage and query via external tables.
Change the billing model to flat-rate.
50 questions · hints · full answers · grading
Expert