Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Google Cloud Certified Professional Cloud Architect · Google Cloud
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Configure a Cloud SQL instance with high availability enabled: While Cloud SQL for SQL Server offers an automated High Availability (HA) option, it does not guarantee "no downtime". During a zonal failover, Cloud SQL has to unbind the persistent disk from the primary VM, spin up the standby VM in the healthy zone, reattach the disk, and run database recovery. This process creates a noticeable failover delay/downtime window (typically taking 60 to 120 seconds), which violates management's explicit constraint.
Gemini said D, and it was talking about MS SQL server.
If the requirement is NO downtime, Cloud SQL does not meet the standard because of its failover delay. Instead, Always On Availability Groups on Compute Engine provide the most reliable, enterprise-grade SQL Server HA solution on GCP.