How to recover from BigQuery table corruption within 7 days with lowest RPO?
You are designing a fault-tolerant architecture to store data in a regional BigQuery dataset. You need to ensure that your application is able to recover from a corruption event in your tables that occurred within the past seven days. You want to adopt managed services with the lowest RPO and most cost-effective solution. What should you do?
Community Votes
100% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
The question tests understanding of BigQuery's time travel and snapshots for disaster recovery, with the trap being that daily snapshots seem reliable but have a 24-hour RPO and extra costs.
Time travel in BigQuery provides built-in point-in-time recovery for up to seven days, offering the lowest RPO at no extra cost, making it the best choice for recovering from table corruption. Community experts agree that daily snapshots are less optimal due to a higher RPO and additional storage costs.
Option C (daily table snapshots) is the most likely wrong choice because it appears to be a managed backup solution, but it introduces up to 24 hours of data loss and ongoing storage costs, whereas time travel provides immediate recovery with zero extra cost.
Community Discussion (6 comments)
- Lowest RPO: Time travel offers point-in-time recovery for the past seven days by default, providing the shortest possible recovery point objective (RPO) among the given options. You can recover data to any state within that window. - No Additional Costs: Time travel is a built-in feature of BigQuery, incurring no extra storage or operational costs. - Managed Service: BigQuery handles time travel automatically, eliminating manual backup and restore processes.
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
Option A, using BigQuery time travel, is the best answer because it offers point-in-time recovery for any moment within the past seven days, giving the lowest possible RPO (seconds to minutes) with no additional storage or operational costs. BigQuery time travel is a fully managed built-in feature, so no separate backup infrastructure is required. The top comment (15 likes) explains that time travel provides 'the shortest possible recovery point objective' and incurs 'no additional costs', directly matching the question's requirements.Why the Other Options Are Wrong
Option B (exporting data to a new table) is a manual and error-prone process that cannot precisely restore the pre-corruption state; it also relies on having an earlier backup or external copy. Option C (daily table snapshots) does provide a managed recovery mechanism, but as a commenter notes, the RPO is 'at most 24 hours', which is higher than time travel's granular recovery, and snapshots involve storage costs. Option D (migrating to multi-region BigQuery buckets) is unrelated to table-level corruption recovery and does not help restore individual tables.Community Comment Notes
The top voted comment (15 likes) strongly supports A, highlighting time travel's zero cost and lowest RPO. A dissenting comment (1 like) argued for C, but its own reasoning admits daily snapshots have an RPO of up to 24 hours—this actually reinforces why C is inferior. Multiple additional comments simply vote for A. The consensus is clear: time travel is the correct, cost-effective managed solution for recovering within the seven-day retention window.Official Reference
Exam Strategy
When a question asks for the lowest RPO and most cost-effective managed solution, check if the data is within the seven-day time travel window. Remember that BigQuery time travel is free and provides second-level granularity, while table snapshots are better for longer retention but cost extra and have a higher RPO.