Topic 1 Question 103
You have a data stored in BigQuery. The data in the BigQuery dataset must be highly available. You need to define a storage, backup, and recovery strategy of this data that minimizes cost. How should you configure the BigQuery table that have a recovery point objective (RPO) of 30 days?
Set the BigQuery dataset to be regional. In the event of an emergency, use a point-in-time snapshot to recover the data.
Set the BigQuery dataset to be regional. Create a scheduled query to make copies of the data to tables suffixed with the time of the backup. In the event of an emergency, use the backup copy of the table.
Set the BigQuery dataset to be multi-regional. In the event of an emergency, use a point-in-time snapshot to recover the data.
Set the BigQuery dataset to be multi-regional. Create a scheduled query to make copies of the data to tables suffixed with the time of the backup. In the event of an emergency, use the backup copy of the table.
ユーザの投票
コメント(15)
Should be D while point-in-time query only access data fron recent 7 days
👍 3bigquery11022022/09/06- 正解だと思う選択肢: C
C for high availability and use of built-in feature
Point-in-time snapshots only have data from the past 7 days at their creation. They can be stored for as long as desired. https://cloud.google.com/bigquery/docs/table-snapshots-intro#table_snapshots
👍 3max_c2022/09/19 - 正解だと思う選択肢: C
C. Set the BigQuery dataset to be multi-regional. In the event of an emergency, use a point-in-time snapshot to recover the data.
👍 2AWSandeep2022/09/03
シャッフルモード