Topic 1 Question 37
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?
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.
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.
Create a clone of the table. On deletion, re-create the deleted table by copying the content of the clone.
Create a view of the table. On deletion, re-create the deleted table from the view and time travel data.
ユーザの投票
コメント(2)
- 正解だと思う選択肢: B
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.
👍 1n21837128472025/02/27 - 正解だと思う選択肢: B
B. is most comprehensive prevention of data loss
👍 1n21837128472025/03/08
シャッフルモード