Answer-first summary for fast verification
Answer: If the corruption is significant, use backup and restore, and specify a recovery timestamp., If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
In a scenario where data corruption occurs in a PITR-enabled Cloud Spanner instance, the approach to recovery depends on the extent of the corruption. For significant corruption, using backup and restore with a specified recovery timestamp (Option A) is the most reliable method to restore the database to a state before the corruption occurred. This leverages Cloud Spanner's point-in-time recovery feature. For insignificant corruption, performing a stale read with a specified recovery timestamp and writing the results back (Option E) is more efficient as it allows for targeted recovery without the need for a full restore. Options B and C are less ideal; stale reads are not meant for significant data recovery, and import/export is not suitable for point-in-time recovery. Option D is incorrect because even for insignificant corruption, backup and restore is an overkill when a stale read can suffice.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You launched a successful mobile game and utilize a 50 TB Cloud Spanner instance with PITR for storing game data in production. Upon reviewing game analytics, you discovered players exploiting a loophole to gain unfair points and climb the leaderboard. Additionally, a DBA mistakenly executed an emergency bugfix script that corrupted some production data. You must assess the scope of the corruption and restore the production environment. What steps should you take? (Select two.)
A
If the corruption is significant, use backup and restore, and specify a recovery timestamp.
B
If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
C
If the corruption is significant, use import and export.
D
If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
E
If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.