Topic 1 Question 78
Your applications will be writing their logs to BigQuery for analysis. Each application should have its own table. Any logs older than 45 days should be removed. You want to optimize storage and follow Google-recommended practices. What should you do?
Configure the expiration time for your tables at 45 days
Make the tables time-partitioned, and configure the partition expiration at 45 days
Rely on BigQuery's default behavior to prune application logs older than 45 days
Create a script that uses the BigQuery command line tool (bq) to remove records older than 45 days
ユーザの投票
コメント(17)
Could you please help clarify? I think B is correct. It looks like table will be deleted with option A. https://cloud.google.com/bigquery/docs/managing-tables#updating_a_tables_expiration_time When you delete a table, any data in the table is also deleted. To automatically delete tables after a specified period of time, set the default table expiration for the dataset or set the expiration time when you create the table.
👍 36KouShikyou2019/10/11Agreed with B.
👍 10aviv2019/12/15- 正解だと思う選択肢: B
B is the correct answer,
If your tables are partitioned by date, the dataset's default table expiration applies to the individual partitions. You can also control partition expiration using the time_partitioning_expiration flag in the bq command-line tool or the expirationMs configuration setting in the API. When a partition expires, data in the partition is deleted but the partitioned table is not dropped even if the table is empty.
https://cloud.google.com/bigquery/docs/best-practices-storage
👍 3examch2022/12/28
シャッフルモード