Google
PROFESSIONAL-CLOUD-ARCHITECT · Question #133
Your applications will be writing their logs to BigQuery for analysis. Each application should have its own table. Any logs older than 45 days should be removed. You want to optimize storage and follo
The correct answer is B. Make the tables time-partitioned, and configure the partition expiration at 45 days. https://cloud.google.com/bigquery/docs/best-practices-storage
Submitted by anjalisingh· Mar 30, 2026Managing and provisioning cloud solution infrastructure
Question
Your applications will be writing their logs to BigQuery for analysis. Each application should have its own table. Any logs older than 45 days should be removed. You want to optimize storage and follow Google-recommended practices. What should you do?
Options
- AConfigure the expiration time for your tables at 45 days
- BMake the tables time-partitioned, and configure the partition expiration at 45 days
- CRely on BigQuery's default behavior to prune application logs older than 45 days
- DCreate a script that uses the BigQuery command line tool (bq) to remove records older than 45
How the community answered
(22 responses)- A5% (1)
- B82% (18)
- C9% (2)
- D5% (1)
Explanation
https://cloud.google.com/bigquery/docs/best-practices-storage
Topics
#BigQuery#time-partitioned tables#partition expiration#log management
Community Discussion
No community discussion yet for this question.