Google Cloud Professional Cloud Database Engineer — Question 26

You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?

Answer options

• A. Set your production instance's maintenance window to non-business hours.
• B. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
• C. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
• D. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.

Correct answer: A

Explanation

The correct answer is A because scheduling maintenance during non-business hours minimizes the impact on production applications. Option B, while a valid solution, involves a significant migration that may not be necessary. Option C is reactive and does not prevent future issues, and Option D does not effectively address the core problem of downtime during maintenance events.