ExpertMedium1 markMultiple Choice
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)
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:
A.
Partition the table by date.
B.
Cluster the table by date.
C.
Require a partition filter on all queries.
D.
Export the data to Cloud Storage and query via external tables.
E.
Change the billing model to flat-rate.
How to approach this question
Identify BigQuery cost optimization techniques.
Full Answer
Partition the table by date.
Require a partition filter on all queries.
Partitioning by date physically divides the table. Requiring a partition filter ensures users cannot accidentally run a query without a date limit, preventing massive bills.
Common mistakes
Choosing clustering instead of partitioning for strict date boundaries.
Practice the full GCP Professional Cloud Architect Practice Exam 2
50 questions · hints · full answers · grading
More questions from this exam
Q01CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...MediumQ02CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...MediumQ03CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...HardQ04CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...MediumQ05CASE STUDY: TechStream Gaming. 500 emp, $100M rev. On-prem US/EU, 200 servers, MySQL 5TB. 2M peak...Easy