Google Exam Professional Cloud Database Engineer Topic 8 Question 35 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 35
Topic #: 8

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

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 results back.

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 results back.

Show Suggested Answer

Suggested Answer: D

BMS is the only Google database service which supports Oracle aside from GCVE. It allows you to use all native Oracle features including RAC. Since GCVE isn't mentioned, it has to be D - Bare Metal Solution.

by Clarence at Jun 18, 2024, 03:30 AM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Cherry

2 days ago

Well, well, well, looks like we've got a good ol' fashioned data disaster on our hands. If it's a significant corruption, I'd probably go with option A. Backup and restore is the classic move, and who doesn't love a good recovery timestamp? It's like a time machine for your data!

upvoted 0 times

...

Keith

8 days ago

Okay, let's think this through. If the corruption is insignificant, D seems like the way to go. But if it's significant, then A or B might be the better options. I'm just hoping I don't have to do the 'import and export' dance. That's like playing 'musical chairs' with the data.

upvoted 0 times

...

Vashti

17 days ago

Hmm, this is a tricky one. Let's see, if the corruption is significant, I'd go with option A or B. Backup and restore with a recovery timestamp seems like the safest bet. Although, a stale read might be faster if I'm feeling adventurous.

upvoted 0 times