Answer-first summary for fast verification
Answer: Configure your Cloud SQL instance with high availability enabled.
To ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users, the best approach is to configure your Cloud SQL instance with high availability enabled (Option D). High availability configuration automatically creates a standby instance in a different zone within the same region. During maintenance, the service automatically fails over to the standby instance, minimizing downtime. Option A suggests configuring a maintenance window during a period when no users will be on the system, but given the application's availability requirements (6 AM to 10 PM, 7 days a week), there's no such period. Option B, creating a read replica, does not directly address the maintenance update issue as read replicas are primarily for read scalability, not high availability. Option C, enabling maintenance notifications, is a good practice but does not prevent downtime during maintenance. Therefore, the correct answer is D.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you schedule regular maintenance updates for your single-region Cloud SQL instance in Google Cloud without causing downtime, given that your application must remain available daily from 6 AM to 10 PM for users in the same time zone?
A
Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
B
Create your database with one primary node and one read replica in the region.
C
Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
D
Configure your Cloud SQL instance with high availability enabled.
No comments yet.