Google Professional Cloud Database Engineer Question 34
Single answerGoogle Cloud PlatformYou are managing a Cloud SQL instance that supports a high-traffic e-commerce application. The application has strict availability requirements and downtime can only be tolerated between 2 AM and 4 AM UTC on Sundays for maintenance. How should you configure the maintenance window and notifications to meet these requirements?
- A
Set the maintenance window to 'Sunday, 2:00 AM to 4:00 AM UTC' and enable email notifications for upcoming maintenance.
- B
Set the maintenance window to 'Any time' and enable email notifications for upcoming maintenance.
- C
Set the maintenance window to 'Sunday, 2:00 AM to 4:00 AM UTC' and disable email notifications.
- D
Set the maintenance window to 'Sunday, 2:00 AM to 4:00 AM UTC' and enable email notifications only for completed maintenance.
Show answer and explanation
Correct answer: A
Explanation
For applications with strict availability requirements, it is important to configure the maintenance window to align with the specified downtime tolerance. Additionally, enabling email notifications ensures the team is alerted to upcoming maintenance and can plan accordingly to minimize disruption.
- A. Correct.
This is the correct option because it matches the application's availability requirements by scheduling maintenance during the specified window and ensures the team is notified in advance of any maintenance activities.
- B. Incorrect.
This option does not meet the application's strict availability requirements because it allows maintenance at any time, which could lead to unplanned downtime.
- C. Incorrect.
While the maintenance window is configured correctly, disabling notifications could result in the team being unaware of upcoming maintenance, which is not ideal for operational planning.
- D. Incorrect.
Enabling notifications only for completed maintenance does not allow the team to prepare for downtime in advance, which is critical for this scenario.