Google Cloud Professional Cloud Database Engineer — Question 39

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?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because configuring a maintenance window when no users are active allows for updates without disrupting service. Option B does not address maintenance scheduling, while C shifts the maintenance time but does not eliminate downtime. Option D enables high availability but does not specifically address the need for regular maintenance without downtime.