nerdexam
GoogleGoogle

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #17

PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #17: Real Exam Question with Answer & Explanation

The correct answer is A: If the corruption is significant, use backup and restore, and specify a recovery timestamp.. https://cloud.google.com/spanner/docs/pitr https://cloud.google.com/spanner/docs/backup/restore-backup

Ensuring database reliability, availability, and recovery

Question

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

Options

  • AIf the corruption is significant, use backup and restore, and specify a recovery timestamp.
  • BIf the corruption is significant, perform a stale read and specify a recovery timestamp. Write the
  • CIf the corruption is significant, use import and export.
  • DIf the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
  • EIf the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the

Explanation

https://cloud.google.com/spanner/docs/pitr https://cloud.google.com/spanner/docs/backup/restore-backup

Topics

#Cloud Spanner#Database Recovery#Point-in-Time Recovery#Backup and Restore

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER PracticeBrowse All PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions