Google Cloud Professional Data Engineer — Question 261

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?

Answer options

• A. Access historical data by using time travel in BigQuery.
• B. Export the data from BigQuery into a new table that excludes the corrupted data
• C. Create a BigQuery table snapshot on a daily basis.
• D. Migrate your data to multi-region BigQuery buckets.

Correct answer: A

Explanation

The correct answer is A because BigQuery's time travel feature allows you to access and restore data as it existed at any point within the last seven days, ensuring minimal data loss. Options B and C do not provide real-time recovery solutions for data corruption, while option D does not directly address the need for recovery from recent corruption events.