Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Professional Cloud Database Engineer Exam - Topic 3 Question 70 Discussion

You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?
C) Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
A) Create a clone database from a read replica database, and restore the clone in the same region.
B) Create a clone database from a read replica database, and restore the clone into a different zone.
D) Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.

Google Professional Cloud Database Engineer Exam - Topic 3 Question 70 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 70
Topic #: 3
[All Professional Cloud Database Engineer Questions]

You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: C

Using import/export from last week is slow for large scale databases and will restore database from last week.


by Delmy at May 06, 2026, 08:56 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Una
4 days ago
Yeah, last week's dump might miss recent changes.
upvoted 0 times
...
Jaime
9 days ago
D could work too, but it’s not as recent.
upvoted 0 times
...
Marti
14 days ago
True, C gives you a specific point in time.
upvoted 0 times
...
Mose
19 days ago
But A might not get you the exact state you need.
upvoted 0 times
...
Una
24 days ago
I prefer A. Cloning from a read replica seems safer.
upvoted 0 times
...
Eveline
30 days ago
PITR is designed for this. Quick recovery!
upvoted 0 times
...
Marti
1 month ago
Why C?
upvoted 0 times
...
Eveline
1 month ago
I think option C is the best.
upvoted 0 times
...
Edward
2 months ago
B is interesting, but why change zones?
upvoted 0 times
...
Linwood
2 months ago
Wait, can you really restore from two hours ago? Sounds risky.
upvoted 0 times
...
Jennie
2 months ago
D seems outdated, why not use PITR?
upvoted 0 times
...
Vanna
2 months ago
I think A could work too, but not as efficient.
upvoted 0 times
...
Renea
2 months ago
C is the best option for quick recovery!
upvoted 0 times
...
Brent
2 months ago
Importing a dump file seems risky since it might not have the latest data, but I guess it could be an option if everything else fails.
upvoted 0 times
...
Kaycee
4 months ago
I practiced a question similar to this, and I feel like using PITR is the most straightforward way to get back to a specific time.
upvoted 0 times
...
Lai
4 months ago
I think creating a clone from a read replica could work, but I can't recall if it has to be in the same region or if it can be in a different zone.
upvoted 0 times
...
France
4 months ago
I remember something about point-in-time recovery being really useful for restoring databases, but I'm not sure if it's the best option here.
upvoted 0 times
...

Save Cancel