Google Professional Cloud Database Engineer Question 35
Select 2Google Cloud PlatformYou are managing a Cloud SQL instance hosting a critical application database. The application requires 99.95% availability and serves global users. To minimize user impact during maintenance, you need to configure the maintenance window and notifications appropriately. What should you do?
- A
Set the maintenance window during non-peak hours for the majority of your users.
- B
Enable email notifications for maintenance updates to stay informed about planned maintenance events.
- C
Disable all maintenance windows to ensure that no maintenance is performed automatically.
- D
Schedule the maintenance window during peak hours to ensure operations teams are available to monitor the system.
- E
Use the Google Cloud Console to monitor maintenance schedules but avoid configuring a maintenance window.
Show answer and explanation
Correct answers: A, B
Explanation
Configuring a maintenance window during non-peak hours minimizes downtime impact on users, while enabling email notifications ensures proactive communication about maintenance events. These are best practices to maintain high availability and meet SLA requirements.
- A. Correct.
Setting the maintenance window during non-peak hours for the majority of your users minimizes the impact on application availability, aligning with the 99.95% SLA requirement.
- B. Correct.
Enabling email notifications ensures you are informed about upcoming maintenance events, providing time to prepare and communicate with stakeholders.
- C. Incorrect.
Disabling all maintenance windows is not an option, as managed services like Cloud SQL require periodic maintenance to ensure security and performance.
- D. Incorrect.
Scheduling maintenance during peak hours increases the likelihood of user impact, which contradicts the goal of maintaining high availability.
- E. Incorrect.
Monitoring maintenance schedules without configuring a maintenance window does not guarantee that maintenance will happen at a convenient time, risking user disruption.