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?
- A. Schedule a daily export of the table to a Cloud Storage dual or multi-region bucket.
- B. Schedule a daily copy of the dataset to a backup region.
- C. Schedule a daily BigQuery snapshot of the table.
- D. Modify ETL job to load the data into both the current and another backup region.
A table snapshot must be in the same region, and under the same organization, as its base table. https://cloud.google.com/bigquery/docs/table-snapshots-intro#limitations
https://cloud.google.com/bigquery/docs/locations
According this documentation "Selecting a multi-region location does not provide cross-region replication or regional redundancy, so there is no increase in dataset availability in the event of a regional outage. Data is stored in a single region within the geographic location. Data located in the EU multi-region is only stored in the europe-west1 (Belgium) or europe-west4 (Netherlands) data centers" So, multi-region dataset just means locating data inside one of US regions, hence snapshot also will be stored in the same region