Trang chủ Professional Data Engineer 225 / 343
Quay lại bộ đề
Question #225 Topic 1
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?
A
1. Create a BigQuery table clone.2. Query the clone when you need to perform analytics.
B
1. Create a BigQuery table snapshot.2. Restore the snapshot when you need to perform analytics.
C
1. Perform a BigQuery export to a Cloud Storage bucket with archive storage class.2. Enable versioning on the bucket.3. Create a BigQuery external table on the exported files.
D
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.