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
Kaycee
1 month 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
1 month 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
1 month 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