Exam Professional Cloud Database Engineer topic 1 question 31 discussion

B. A is wrong. The cloudsql.googleapis.com/postgres.log log file could be used to find out who started the backup operation, not the status of the operation. C is wrong for a similar reason. D is partially right. In the console there’s an Operations option in the menu on the left. Click that and it shows “Creating backup” together a start time. That’s not a million miles different from the gcloud sql operations list command which shows similar output except there’s a STATUS: line showing the word RUNNING while the backup is in progress. Given the question specifically mentions “status”, B would be the better answer. Just.

gcloud sql backup list --instance= instance-id will give the status of backup for that particular instance. So B is good.

B to get the status using gcloud. D is possible but as mentioned, it doesn't specifically mention where in the console so B is a better answer.

If you want the status of the backup, then gcloud is the only viable option, as the Audit Logs will just tell you who started it.

Using the Google Cloud Console is the most straightforward and convenient method for verifying the status of an on-demand backup for your mission-critical Cloud SQL for PostgreSQL instance. It provides a graphical interface that displays the backup status and any relevant details, enabling you to quickly assess the situation and ensure the integrity of your important transactions.

option C is to find out who started the backup, for the status B is correct

B should the right answer: via gcloud sql operations list --instance=<instance_name> gcloud alpha sql operations list --instance=<instance_name>

Should be B Perform the gcloud sql operations list command https://cloud.google.com/sql/docs/postgres/backup-recovery/backups#troubleshooting-backups Under Troubleshooting: Issue: "You can't see the current operation's status." The Google Cloud console reports only success or failure when the operation is done. It isn't designed to show warnings or other updates. Run the gcloud sql operations list command to list all operations for the given Cloud SQL instance. A and C iis wrong because there are used for WHO issued the Backup, but not the current status of the backup D is wrong only shows success or failure in the Cloud Console but not the current status of the backup

Vote for B

B: Perform the gcloud sql operations list ***** command.

C is the correct answer.log gives more information

Perform the gcloud sql operations list command.

Correct answer is B. https://cloud.google.com/sql/docs/postgres/backup-recovery/backups#troubleshooting-backups