Google Professional Cloud Database Engineer Question 31
Select 2Google Cloud PlatformYou are managing a Cloud SQL instance hosting a mission-critical application that serves global users. The application has a strict SLA requiring 99.99% uptime and minimal disruption during business hours (9 AM to 5 PM) in the UTC time zone. You need to configure a Cloud SQL maintenance window to minimize impact on users and ensure notifications are sent to the relevant team members. What should you do?
- A
Configure the maintenance window to occur between 1 AM and 3 AM UTC.
- B
Enable email notifications for maintenance updates and add the operations team to the notification list.
- C
Disable maintenance windows to prevent any downtime during maintenance activities.
- D
Set the maintenance window to occur during business hours (9 AM to 5 PM UTC) to ensure faster visibility of any issues.
- E
Configure the maintenance window to occur outside of business hours and ensure the 'Require approval' option is enabled for maintenance.
Show answer and explanation
Correct answers: A, B
Explanation
To meet the SLA and minimize disruption, the maintenance window should be configured outside of business hours (e.g., 1 AM to 3 AM UTC), and notifications should be enabled to keep the operations team informed. Disabling maintenance windows is not an option, and scheduling during business hours violates the SLA. Additionally, the 'Require approval' option is not a feature in Cloud SQL.
- A. Correct.
This is correct because scheduling the maintenance window between 1 AM and 3 AM UTC avoids disruption during business hours, aligning with the application's SLA.
- B. Correct.
This is correct because enabling notifications ensures the operations team is informed of maintenance events, allowing them to prepare and respond if needed.
- C. Incorrect.
This is incorrect because disabling maintenance windows is not allowed in Cloud SQL. Maintenance events are mandatory, and not configuring a specific window could lead to disruptions at random times.
- D. Incorrect.
This is incorrect because scheduling maintenance during business hours goes against the SLA requirement of minimal disruption during operational periods.
- E. Incorrect.
This is incorrect because while scheduling outside business hours is correct, the 'Require approval' option does not exist in Cloud SQL maintenance settings.