Google Cloud Professional Cloud Database Engineer — Question 170

You are running a Cloud SQL for PostgreSQL 13 Enterprise Edition instance. During an audit, you discovered that the write-ahead logs used for point-in-time recovery (PITR) are stored on disk. You need to store PITR logs in a Cloud Storage bucket going forward. How should you do this without compromising recoverability or losing the current PITR logs?

Answer options

• A. Clone the instance. Create a new instance with PITR retention set to 30 days.
• B. Change the transaction logs (WAL) retention period.
• C. Upgrade to Enterprise Plus Edition.
• D. Disable PITR, then enable PITR.

Correct answer: C

Explanation

Upgrading to Enterprise Plus Edition is necessary as it provides the capability to store write-ahead logs in Cloud Storage, ensuring that your PITR logs are managed effectively without losing current logs. The other options do not address the requirement to store logs in Cloud Storage or compromise recoverability.