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

Dong

1 months ago

Ah, the age-old question of 'to restore or not to restore?' If the corruption is insignificant, I'd definitely go with option D. Backup and restore with a recovery timestamp is like a spa day for your data. But if it's significant, A or B might be the way to go. Although, I've got to admit, the 'stale read and write back' move sounds kind of like a dance move from the '80s.

upvoted 0 times

Cherrie

2 days ago

I think we should go with option A if the corruption is significant. Backup and restore with a recovery timestamp seems like the safest bet.

upvoted 0 times

...

Felicitas

2 months ago

This is where the real fun begins! If the corruption is significant, I'd probably go with B. Stale read and write back, baby! It's like playing 'tag' with the data, but with a recovery timestamp as the ultimate 'get out of jail free' card. As for the 'import and export' option, that's just asking for trouble. It's like trying to juggle flaming chainsaws while riding a unicycle.

upvoted 0 times

Ligia

10 days ago

Definitely, we need to be careful with our next move to restore the production environment without causing more issues.

upvoted 0 times

...

Kaitlyn

1 months ago

Yeah, it's like making a calculated risk to ensure the data integrity is maintained. Import and export sounds too risky.

upvoted 0 times

...

Quentin

1 months ago

I agree, using a stale read and write back seems like the best option in this situation. It's like a strategic move in a game.

upvoted 0 times

...

Cherry

2 months 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

Kate

2 days ago

Player1: Let's get this data disaster sorted out quickly.

upvoted 0 times

...

Glen

4 days ago

Player3: Definitely, we need to make sure we can roll back to a safe point.

upvoted 0 times

...

Youlanda

10 days ago

Player2: Agreed, it's a classic move for significant corruption.

upvoted 0 times

...

Dana

14 days ago

Player1: Yeah, backup and restore with a recovery timestamp sounds like the way to go.

upvoted 0 times

...

Keith

2 months 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

Junita

1 months ago

B) If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.

upvoted 0 times

...

Lauryn

1 months ago

A) If the corruption is significant, use backup and restore, and specify a recovery timestamp.

upvoted 0 times

...

Vashti

2 months 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