QuestionQ99

VerifiedData Management

You have a BigQuery dataset that contains sales data. The data is actively queried for the first 6 months. After that, it is not queried but must be retained for 3 years for compliance purposes. You need to implement a data-management strategy that meets the access and compliance requirements while minimizing cost and administrative overhead. What should you do?

Explanation

Monthly partitioning lets historical data be managed by age. After the six-month active-query period, exporting partitions to Cloud Storage Coldline places infrequently accessed data in a low-cost storage class. Cloud Storage Object Lifecycle Management can automatically delete objects when they reach the required retention age, avoiding a custom deletion service or procedure. BigQuery long-term storage is an automatic pricing discount for data unchanged for 90 days, but it does not by itself implement archival retention and deletion.

Learn more

Community Discussion

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