Google Professional Cloud Database Engineer Question 33
Single answerGoogle Cloud PlatformYou are managing a Cloud SQL instance that supports a critical e-commerce application. The application has peak usage during weekdays from 9 AM to 9 PM and experiences minimal traffic during weekends. The application requires minimal downtime to maintain user experience. How should you configure the maintenance window to meet the application's availability requirements?
- A
Set the maintenance window to weekdays from 9 AM to 9 PM.
- B
Set the maintenance window to weekdays from 1 AM to 5 AM.
- C
Set the maintenance window to weekends from 1 AM to 5 AM.
- D
Set the maintenance window to weekends from 9 AM to 9 PM.
Show answer and explanation
Correct answer: C
Explanation
To define an appropriate maintenance window, you should consider the application's traffic patterns and select a period with minimal user activity to reduce the impact of downtime. Since the application's peak usage occurs on weekdays from 9 AM to 9 PM, scheduling maintenance during weekends from 1 AM to 5 AM ensures minimal disruption to the user experience.
- A. Incorrect.
This option would result in downtime during the application's peak usage hours, which is not optimal for maintaining availability.
- B. Incorrect.
Although this option avoids peak usage hours, it still results in downtime during weekdays, when the application is actively used.
- C. Correct.
This is the best option as it avoids peak usage hours and schedules maintenance during a period of minimal traffic, ensuring minimal impact on the application.
- D. Incorrect.
This option would result in downtime during the weekends' daytime, which might still impact some users and is less optimal than scheduling maintenance during early morning hours.