Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 61

Question

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?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance. Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 61