QuestionQ8

VerifiedDeploy scalable and highly available databases in Google Cloud

You released a popular mobile game and use a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. After analyzing game statistics, you discover that some players are exploiting a loophole to collect extra points and reach the leaderboard. Another DBA accidentally executed an emergency bug-fix script that corrupted some production data. You need to assess the extent of the data corruption and restore the production environment. What should you do?

Choose two
Explanation

Cloud Spanner PITR uses stale reads at a timestamp before corruption to surgically recover a portion of a database, after which the recovered results are written back. For significant or whole-database corruption, create a backup at the required recovery timestamp and restore it to a new database. Backup and restore is the appropriate full-database recovery method rather than export/import for this scenario.

Learn more

Community Discussion

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