PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #24
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…
The correct answer is A. Set your production instance's maintenance window to non-business hours. Cloud SQL allows you to configure a maintenance window - a specific day and hour each week when Google can perform disruptive maintenance on your instance. By setting this window to non-business hours (e.g., late night or weekends), you ensure maintenance events happen when…
Question
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?
Options
- ASet your production instance's maintenance window to non-business hours.
- BMigrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to
- CContact Support to understand why your Cloud SQL instance had a downtime of more than 5
- DUse Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
How the community answered
(25 responses)- A84% (21)
- B4% (1)
- C12% (3)
Explanation
Cloud SQL allows you to configure a maintenance window - a specific day and hour each week when Google can perform disruptive maintenance on your instance. By setting this window to non-business hours (e.g., late night or weekends), you ensure maintenance events happen when traffic is low and impact is minimal. This is the direct, built-in solution for controlling when planned maintenance occurs. Option B (migrating to Cloud Spanner) is an extreme overreaction to a maintenance scheduling issue. Option C (contacting Support) is reactive, not preventive. Option D is invalid - Cloud Scheduler cannot manage Cloud SQL maintenance windows.
Topics
Community Discussion
No community discussion yet for this question.