Google Professional Cloud Database Engineer Question 190
Select 2Google Cloud PlatformYou are managing a Cloud SQL for PostgreSQL instance that is running out of disk space due to excessive old data logs and unused tables. To address this, you need to perform maintenance without impacting the database's availability. Which actions should you take?
- A
Enable automatic storage increase for the Cloud SQL instance.
- B
Use the
pg_dumputility to back up the database, and then delete unused tables. - C
Run the
VACUUMcommand to reclaim storage space from deleted rows. - D
Restart the Cloud SQL instance to automatically clear old data logs.
- E
Enable point-in-time recovery and delete the old data logs manually from the instance's file system.
Show answer and explanation
Correct answers: A, C
Explanation
To perform database maintenance without impacting availability, enabling automatic storage increase ensures the database can scale dynamically when disk space runs low. Running the VACUUM command reclaims storage space from deleted rows safely and efficiently. These actions align with best practices for maintaining a Cloud SQL instance while ensuring its availability.
- A. Correct.
Enabling automatic storage increase allows the database to scale its storage dynamically, preventing service disruption when disk space runs low. This is a recommended best practice for managing storage in Cloud SQL.
- B. Incorrect.
While using
pg_dumpis useful for creating backups, manually deleting unused tables can be risky and may cause issues if not planned properly. This is not the most efficient way to manage disk space. - C. Correct.
The
VACUUMcommand is a standard way to reclaim space from deleted rows in PostgreSQL and is a safe operation for database maintenance without downtime. - D. Incorrect.
Restarting the instance does not clear old logs automatically. This is not a valid approach for maintenance in Cloud SQL.
- E. Incorrect.
Point-in-time recovery ensures backups, but manually deleting logs from the file system is not supported in Cloud SQL, as users do not have direct file system access.