You need to recover from accidental table corruption within the past seven days in a regional BigQuery dataset using managed services with lowest RPO and cost. What should you use?
Choose an answer
Tap an option to check your answer.
Correct answer: Access historical data by using time travel in BigQuery..
Why this is the answer
BigQuery's time travel feature allows you to access historical versions of a table for up to seven days. This is the most efficient and cost-effective method for recovering from recent accidental table corruption because it's a built-in, managed service that requires no prior setup and offers the lowest Recovery Point Objective (RPO) by letting you restore to any point within the window. Exporting data to exclude corrupted records is a manual, time-consuming process that doesn't guarantee full recovery to a specific point in time. Daily snapshots would require proactive setup and management, incurring additional storage costs, and might not offer the granular RPO of time travel. Migrating to multi-region buckets is for disaster recovery across regions, not for recovering from localized table corruption within a single region.
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