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?
To minimize storage costs while ensuring immutability for 3 years, the best approach is to export the BigQuery table to a Cloud Storage bucket with the archive storage class, which is the lowest-cost storage class for infrequently accessed data. Setting a locked retention policy on the bucket ensures that the data cannot be modified or deleted until the retention period expires, making it immutable. Creating a BigQuery external table on the exported files allows you to query the data when necessary without moving it back to BigQuery, further reducing costs.
Straight Forward
D. For data keeping till last 3 years, use bucket lock with rentention policy
Option D, clearly
For data keeping till last 3 years, use bucket lock with rentention policy
Option D
voted D