Topic 1 Question 211
You are using BigQuery with a multi-region dataset that includes a table with the daily sales volumes. This table is updated multiple times per day. You need to protect your sales table in case of regional failures with a recovery point objective (RPO) of less than 24 hours, while keeping costs to a minimum. What should you do?
Schedule a daily export of the table to a Cloud Storage dual or multi-region bucket.
Schedule a daily copy of the dataset to a backup region.
Schedule a daily BigQuery snapshot of the table.
Modify ETL job to load the data into both the current and another backup region.
ユーザの投票
コメント(6)
- 正解だと思う選択肢: C
Option C provides cost-effective way.
- BigQuery table snapshots are a feature that allows you to capture the state of a table at a particular point in time.
- Snapshots are incremental, so they only store the data that has changed, making them more cost-effective than full table copies.
- In the event of a regional failure, you can quickly restore the table from a snapshot.
👍 5raaad2024/01/02 Option A
👍 3qq589539483084gfrgrgfr2024/01/04- 正解だと思う選択肢: A
"BigQuery does not offer durability or availability in the extraordinarily unlikely and unprecedented event of physical region loss. This is true for both "regions and multi-region" configurations. Hence maintaining durability and availability under such a scenario requires customer planning."
"To avoid data loss in the face of destructive regional loss, you need to back up data to another geographic location. For example, you could periodically export a snapshot of your data to Google Cloud Storage in another geographically distinct region."
Ref: https://cloud.google.com/bigquery/docs/reliability-intro#scenario_loss_of_region
👍 3Helinia2024/01/06
シャッフルモード