QuestionQ75

VerifiedStoring the data

You have 100 GB of data in a BigQuery table. The data is outdated and will be accessed only once or twice per year for SQL-based analytics. For backup purposes, you need to retain this data immutably for 3 years while minimizing storage costs. What should you do?

Explanation

Cloud Storage Archive provides low-cost storage for infrequently accessed data, and BigQuery can query Archive-class Cloud Storage files through an external table. A locked bucket retention policy makes the retention configuration irreversible: it cannot be removed and its retention period cannot be decreased, thereby preserving the exported data for the required three years. Object versioning alone does not provide that immutable retention guarantee.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!