Exam Professional Cloud Database Engineer topic 1 question 36 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 36
Topic #: 1

[All Professional Cloud Database Engineer Questions]

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

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.

Show Suggested Answer

Suggested Answer: AE 🗳️

by range9005 at Dec. 21, 2022, 4:52 p.m.

Comments

Submit Cancel

chelbsik

Highly Voted 1 year, 1 month ago

Selected Answer: AE

https://cloud.google.com/spanner/docs/pitr#ways-to-recover To recover the entire database, backup or export the database specifying a timestamp in the past and then restore or import it to a new database. This is typically used to recover from data corruption issues when you have to revert the entire database to a point-in-time before the corruption occurred. This part describes significant corruption - A To recover a portion of the database, perform a stale read specifying a query-condition and timestamp in the past, and then write the results back into the live database. This is typically used for surgical operations on a live database. For example, if you accidentally delete a particular row or incorrectly update a subset of data, you can recover it with this method. This describes insignificant corruption case - E

upvoted 12 times

...

dynamic_dba

Most Recent 10 months, 3 weeks ago

A, E. The answers are split between significant and insignificant. For insignificant, the simplest form of recovery would be E. That eliminates D. For significant, let’s assume that means a lot of data of the the 50 TB total. A stale read and write back would probably been too onerous, so that eliminates B. That leaves A and C. The question doesn’t mention anything about logical backups (export) which suggests a restore from a backup would be appropriate of a large amount of data that needed to be recovered. https://cloud.google.com/spanner/docs/pitr https://cloud.google.com/spanner/docs/backup/restore-backup

upvoted 4 times

...

TFMV

1 year, 1 month ago

AE are correct.

upvoted 3 times

...

pk349

1 year, 1 month ago

B: If the corruption is significant, perform a stale ***** read and specify a recovery timestamp. Write the results back. D: If the corruption is insignificant, use backup and ***** restore, and specify a recovery timestamp.

upvoted 1 times

...

range9005

1 year, 1 month ago

Selected Answer: BD

B. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back. D. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.

upvoted 1 times

...

range9005

1 year, 1 month ago

Selected Answer: BC

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.

upvoted 1 times

range9005

1 year, 1 month ago

By mistake

upvoted 1 times

...