Google
PROFESSIONAL-CLOUD-ARCHITECT · Question #119
You need to set up Microsoft SQL Server on GCP. Management requires that there's no downtime in case of a data center outage in any of the zones within a GCP region. What should you do?
Sign in or unlock PROFESSIONAL-CLOUD-ARCHITECT to reveal the answer and full explanation for question #119. The question stem and answer options stay visible for context.
Submitted by lars.no· Mar 30, 2026Designing and planning a cloud solution architecture
Question
You need to set up Microsoft SQL Server on GCP. Management requires that there's no downtime in case of a data center outage in any of the zones within a GCP region. What should you do?
Options
- AConfigure a Cloud SQL instance with high availability enabled.
- BConfigure a Cloud Spanner instance with a regional instance configuration.
- CSet up SQL Server on Compute Engine, using Always On Availability Groups using Windows
- DSet up SQL Server Always On Availability Groups using Windows Failover Clustering. Place
Unlock PROFESSIONAL-CLOUD-ARCHITECT to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-ARCHITECT questions. Unlock PROFESSIONAL-CLOUD-ARCHITECT for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Cloud SQL#high availability#SQL Server#zonal failover