Protect a frequently-updated multi-region BigQuery table (daily updates) against regional failures with RPO < 24 hours at minimal cost. What should you do?
Choose an answer
Tap an option to check your answer.
Correct answer: Schedule a daily export of the table to a dual- or multi-region Cloud Storage bucket..
Why this is the answer
Exporting the BigQuery table to a dual- or multi-region Cloud Storage bucket daily meets the RPO < 24 hours requirement and offers a cost-effective solution for disaster recovery. Cloud Storage provides high durability and availability across regions. Copying the dataset to a backup region is more expensive and might not be supported for cross-region BigQuery dataset copies directly. BigQuery snapshots are primarily for point-in-time recovery within the same region, not cross-regional disaster recovery. Modifying the ETL to write to both regions increases complexity, introduces potential latency issues, and doubles BigQuery storage and processing costs, making it less cost-effective.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed