You manage a BigQuery table that is used for critical end-of-month reports. The table is updated weekly with new sales data. You want to prevent data loss and reporting issues if the table is accidentally deleted. What should you do?
A.
Configure the time travel duration on the table to be exactly seven days. On deletion, re-create the deleted table solely from the time travel data.
B.
Schedule the creation of a new snapshot of the table once a week. On deletion, re-create the deleted table using the snapshot and time travel data.
C.
Create a clone of the table. On deletion, re-create the deleted table by copying the content of the clone.
D.
Create a view of the table. On deletion, re-create the deleted table from the view and time travel data.
The best solution to prevent data loss and recover from accidental table deletion is B. Schedule weekly snapshots and use them with time travel for recovery. Weekly snapshots provide regular, reliable backups. If deletion occurs, restore from the latest snapshot, potentially supplemented by time travel for very recent data if needed. Option C (Clones) is a decent backup alternative, but snapshots are generally preferred for backup purposes. Option A (Time Travel alone) is too limited by its 7-day window. Option D (Views) provides no data protection against table deletion. Therefore, Option B offers the most robust and comprehensive data protection strategy.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
n2183712847
1 month, 3 weeks agon2183712847
2 months ago