Google Professional Cloud Database Engineer Question 32
Single answerGoogle Cloud PlatformYour team is running a mission-critical e-commerce application on Google Cloud using Cloud SQL for PostgreSQL. The application is busiest during weekends, and any downtime during this period could result in significant revenue loss. You need to configure a maintenance window for the database while ensuring minimal impact on application availability. Which configuration should you choose?
- A
Schedule the maintenance window for weekdays during off-peak hours, such as 1:00 AM to 5:00 AM.
- B
Disable the maintenance window to prevent updates and avoid any downtime.
- C
Schedule the maintenance window for weekends during non-peak hours, such as 1:00 AM to 5:00 AM.
- D
Leave the maintenance window unspecified to let Google Cloud automatically schedule updates.
Show answer and explanation
Correct answer: A
Explanation
To minimize downtime and ensure high availability for mission-critical applications, maintenance windows should be scheduled during off-peak hours when the impact on the application is minimal. Since the application is busiest during weekends, scheduling updates during weekdays in the early morning (off-peak hours) is the optimal solution. This allows for necessary updates while avoiding disruptions during the application's busiest periods.
- A. Correct.
Scheduling the maintenance window for weekdays during off-peak hours ensures that updates occur when the application has minimal usage, reducing the risk of impacting the busiest times (weekends). This is the best approach based on the scenario.
- B. Incorrect.
Disabling the maintenance window is not recommended because it prevents important updates, such as security patches, which could lead to vulnerabilities or performance issues.
- C. Incorrect.
Scheduling the maintenance window for weekends, even during non-peak hours, risks impacting the critical revenue-generating period if the updates take longer than expected or encounter issues.
- D. Incorrect.
Leaving the maintenance window unspecified allows Google Cloud to determine the window, which could result in updates happening during critical periods, such as weekends in this case. This does not align with the application's availability requirements.