Google Cloud Professional Cloud Database Engineer — Question 20

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?

Answer options

• A. Check the cloudsql.googleapis.com/postgres.log instance log.
• B. Perform the gcloud sql operations list command.
• C. Use Cloud Audit Logs to verify the status.
• D. Use the Google Cloud Console.

Correct answer: B

Explanation

The correct answer is B, as the gcloud sql operations list command specifically provides details about ongoing operations, including backups. Option A, while it provides logging information, does not directly indicate backup status. Option C, Cloud Audit Logs, tracks actions but is not primarily used for real-time backup status. Option D, the Google Cloud Console, can provide insights but is less direct than using the gcloud command for this specific task.