Associate Data Practitioner

By Google · Question Mode

QuestionQ5

Data Management

You manage a BigQuery table used for critical end-of-month reporting. The table receives new sales data every week. You need to avoid data loss and reporting problems if the table is accidentally deleted. What should you do?

Explanation

BigQuery table snapshots retain a point-in-time copy independently of the base table and can be restored to a writable table. They provide retention beyond BigQuery time travel’s maximum seven-day recovery window, while time travel can recover more recent changes made after the latest weekly snapshot when the deletion is within that window.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!