PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #113
You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. Most of your users are located in the same time zone and expect the ap
The correct answer is A. Configure a maintenance window during a period when no users will be on the system. Control. Since users only access the application between 6 AM and 10 PM, configuring a maintenance window during off-hours (e.g., 10 PM–6 AM) ensures Cloud SQL can apply updates without impacting any active users. Option B (read replica) improves read performance and availability for read
Question
You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?
Options
- AConfigure a maintenance window during a period when no users will be on the system. Control
- BCreate your database with one primary node and one read replica in the region.
- CEnable maintenance notifications for users, and reschedule maintenance activities to a specific
- DConfigure your Cloud SQL instance with high availability enabled.
How the community answered
(33 responses)- A91% (30)
- C6% (2)
- D3% (1)
Explanation
Since users only access the application between 6 AM and 10 PM, configuring a maintenance window during off-hours (e.g., 10 PM–6 AM) ensures Cloud SQL can apply updates without impacting any active users. Option B (read replica) improves read performance and availability for reads but does not prevent maintenance downtime on the primary. Option C (notifications and rescheduling) does not guarantee a maintenance-free window. Option D (high availability) protects against instance failure with automatic failover but does not eliminate maintenance windows-HA instances still undergo maintenance, just with a faster failover. A scheduled maintenance window is the simplest and most direct solution to the stated requirement.
Topics
Community Discussion
No community discussion yet for this question.