Answer-first summary for fast verification
Answer: 1. Perform a BigQuery export to a Cloud Storage bucket with archive storage class. 2. Set a locked retention policy on the bucket. 3. Create a BigQuery external table on the exported files.
Option D is the correct answer because it involves exporting the data to a Cloud Storage bucket with archive storage class, setting a locked retention policy on the bucket, and creating a BigQuery external table on the exported files. This approach minimizes storage costs while ensuring the data remains immutable for the required period of 3 years. The use of the archive storage class helps in reducing storage costs significantly, and the locked retention policy ensures that the data cannot be altered or deleted during the retention period.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You have a BigQuery table containing 100 GB of outdated data, which will be accessed only once or twice a year for analytics via SQL. For backup purposes, you need to store this data in an unchangeable format for a duration of three years. Your goal is to minimize the associated storage costs. How should you proceed?
A
B
C
D
No comments yet.