Topic 1 Question 15
You have a BigQuery dataset containing sales data. This data is actively queried for the first 6 months. After that, the data is not queried but needs to be retained for 3 years for compliance reasons. You need to implement a data management strategy that meets access and compliance requirements, while keeping cost and administrative overhead to a minimum. What should you do?
Use BigQuery long-term storage for the entire dataset. Set up a Cloud Run function to delete the data from BigQuery after 3 years.
Partition a BigQuery table by month. After 6 months, export the data to Coldline storage. Implement a lifecycle policy to delete the data from Cloud Storage after 3 years.
Set up a scheduled query to export the data to Cloud Storage after 6 months. Write a stored procedure to delete the data from BigQuery after 3 years.
Store all data in a single BigQuery table without partitioning or lifecycle policies.
ユーザの投票
コメント(1)
- 正解だと思う選択肢: B
The best option is B. Partition a BigQuery table by month. After 6 months, export the data to Coldline storage. Implement a lifecycle policy to delete the data from Cloud Storage after 3 years. Option B provides the optimal balance of meeting the 3-year data retention requirement, achieving excellent cost optimization by tiering data to Coldline, and maintaining reasonable administrative overhead. Option C is more complex and less clear on overall retention and cost due to data duplication. Option D is the simplest administratively but provides the worst cost optimization. Option A is not cost-optimized and has moderate overhead. Therefore, Option B is the most practical and well-rounded solution for this data management scenario.
👍 1n21837128472025/02/27
シャッフルモード