Google Cloud Professional Cloud Database Engineer — Question 33

You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)

Answer options

• 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.

Correct answer: A, E

Explanation

Option A is correct because using backup and restore with a specified recovery timestamp is the best method to recover from significant corruption. Option E is also correct as performing a stale read for minor corruption allows for recovery without utilizing backups, ensuring that only recent valid data is restored. Options B, C, and D are incorrect because they either misinterpret the extent of the corruption or suggest inappropriate recovery methods for the given scenarios.