How to minimize costs for immutable BigQuery backups?
You have 100 GB of data stored in a BigQuery table. This data is outdated and will only be accessed one or two times a year for analytics with SQL. For backup purposes, you want to store this data to be immutable for 3 years. You want to minimize storage costs. What should you do?
Community Votes
100% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
This question tests knowledge of Cloud Storage classes for cost optimization and the use of Bucket Locks for data immutability, distinguishing them from BigQuery native features like snapshots.
To minimize costs for rarely accessed BigQuery data requiring immutability, export the data to a Cloud Storage bucket using the Archive storage class and configure a Bucket Lock. The community consensus confirms this is the most cost-effective method to meet the 3-year retention requirement.
Choosing BigQuery snapshots (Option B) is a common error because, while they preserve data, they are more expensive than Cloud Storage Archive class for long-term cold storage and lack specific WORM compliance features.
Community Discussion (6 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
Option D is the correct choice because exporting to Cloud Storage with the Archive storage class provides the lowest cost for data accessed less than once a year. To meet the immutability requirement for 3 years, a Bucket Lock or retention policy must be applied to the bucket, ensuring the data cannot be modified or deleted during that period.Why the Other Options Are Wrong
BigQuery table clones (Option A) and snapshots (Option B) keep the data within BigQuery, which is more expensive than Cloud Storage Archive. While snapshots are useful for point-in-time recovery, they do not inherently provide the strict immutability (WORM) guarantees required for compliance-heavy backups like a Bucket Lock does.Community Comment Notes
Community members strongly support Option D, specifically noting the necessity of using a "bucket lock with retention policy" to satisfy the 3-year immutability constraint. The comments indicate that the combination of exporting to cold storage and applying a lock is the standard solution for this scenario.Official Reference
Exam Strategy
When a question requires data to be immutable for a specific duration, look for Cloud Storage Bucket Lock or retention policies rather than database snapshots. Always prioritize the Archive storage class for data accessed once a year or less to ensure the lowest storage costs.