Free Google Professional Cloud Database Engineer Actual Exam Questions - Question 6 Discussion
SQL for transactional dat
a. 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?
Option A also makes sense since scheduling maintenance during off-hours can minimize user impact, but it doesn't fully prevent downtime like HA does. It’s more about timing than avoiding downtime altogether.
D. High availability is designed to keep the instance available during maintenance by failing over to a standby, so no downtime should occur. B with a read replica helps with read scaling but doesn’t prevent downtime for writes during maintenance on the primary. The question stresses no downtime, not just read availability, so HA is more aligned with that need. Maintenance windows (A) or notifications (C) don’t eliminate downtime, just try to minimize user impact. So, enabling HA seems like the most straightforward way to ensure continuous availability during updates.
D makes sense for avoiding downtime, but does B help by offloading reads to replicas during maintenance? Could that reduce impact without full HA setup? Wonder if read replicas alone are enough here.
D sounds best since high availability helps avoid downtime during maintenance by failing over automatically. A might work but users are active until 10 PM, so it’s tough to find a no-user period.