PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #202
You are running a mission-critical application on Google Kubernetes Engine (GKE) and you are using private IP to connect to Cloud SQL for PostgreSQL in us-central1. You want to maximize database uptim
The correct answer is C. Upgrade to the Cloud SAL Enterprise Plus edition.. Upgrading to Cloud SQL Enterprise Plus edition is the correct choice to maximize uptime during planned maintenance events. Enterprise Plus provides near-zero downtime maintenance updates, where the instance failovers to a standby replica with sub-second interruption instead of ta
Question
You are running a mission-critical application on Google Kubernetes Engine (GKE) and you are using private IP to connect to Cloud SQL for PostgreSQL in us-central1. You want to maximize database uptime without making any major changes to the application in case of a planned event, such as maintenance. What should you do-
Options
- AEnable Automated backups and configure the retention period to 365 days.
- BCreate a cross-region read replica in us-south1.
- CUpgrade to the Cloud SAL Enterprise Plus edition.
- DSet up notifications about upcoming maintenance sent to your email at least one week before
How the community answered
(27 responses)- A4% (1)
- B11% (3)
- C81% (22)
- D4% (1)
Explanation
Upgrading to Cloud SQL Enterprise Plus edition is the correct choice to maximize uptime during planned maintenance events. Enterprise Plus provides near-zero downtime maintenance updates, where the instance failovers to a standby replica with sub-second interruption instead of taking several minutes of downtime. It also allows maintenance windows to be configured with more granular control. Option A (automated backups) helps with data recovery after an outage but does not reduce downtime during planned maintenance. Option B (cross-region read replica) improves disaster recovery and read scaling but does not provide automatic failover for planned maintenance. Option D (email notifications) informs you about upcoming maintenance but does nothing to prevent or minimize the downtime itself.
Topics
Community Discussion
No community discussion yet for this question.