Exam Professional Cloud Architect topic 1 question 78 discussion

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.

Agreed with B.

I think B is correct.

https://cloud.google.com/bigquery/docs/managing-partitioned-tables#partition-expiration B is the correct answer.

https://cloud.google.com/bigquery/docs/managing-partitioned-tables#partition-expiration

B is correct

B seems correct as this will partitioning will create a filter criteria on the basis of which specified actions on logs will be taken

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

B is ok

B - You can control partition expiration using the time_partitioning_expiration flag in the bq command-line https://cloud.google.com/bigquery/docs/best-practices-storage

B is okay

Using Table-Partitions.

Using Table-Partitions.

I got similar question on my exam.

Go for B. https://cloud.google.com/bigquery/docs/creating-partitioned-tables#sql CREATE TABLE mydataset.newtable (transaction_id INT64, transaction_date DATE) PARTITION BY transaction_date OPTIONS( partition_expiration_days=3, require_partition_filter=true )

B is the correct answer

B – Make the tables time-partitioned and configure the partition expiration at 45 days. A – if you use table expiration time, then it will remove the whole table after 45 days. D – requires extra work and is not automatic.