Question 128 of 139
Single answerYou 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?
ACreate a clone database from a read replica database, and restore the clone in the same region.
BCreate a clone database from a read replica database, and restore the clone into a different zone.
✓CUse the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
DUse the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.
✓
Correct Answer: C
Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.