PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #12
You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want…
The correct answer is B. Perform the gcloud sql operations list command. The gcloud sql operations list command returns a list of all Cloud SQL operations - including backups, restores, and imports - along with their current status (PENDING, RUNNING, DONE, or ERROR). This is the direct and precise way to monitor backup progress from the command…
Question
You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?
Options
- ACheck the cloudsql.googleapis.com/postgres.log instance log.
- BPerform the gcloud sql operations list command.
- CUse Cloud Audit Logs to verify the status.
- DUse the Google Cloud Console.
How the community answered
(47 responses)- A2% (1)
- B89% (42)
- C2% (1)
- D6% (3)
Explanation
The gcloud sql operations list command returns a list of all Cloud SQL operations - including backups, restores, and imports - along with their current status (PENDING, RUNNING, DONE, or ERROR). This is the direct and precise way to monitor backup progress from the command line. Cloud Audit Logs (C) record API calls for security and compliance auditing but are not designed for real-time operational status checks. The postgres.log (A) contains database-level activity logs but does not report on Cloud SQL backup operation state. While the Google Cloud Console (D) can show backup status, the gcloud sql operations list command is the recommended practice for programmatic, scriptable, and efficient status verification.
Topics
Community Discussion
No community discussion yet for this question.