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?

The correct answer is A. Configure a Cloud SQL instance with high availability enabled. high availability (HA) configuration for Cloud SQL instances... A Cloud SQL instance configured for HA is also called a regional instance and is located in a primary and secondary zone within the configured region.In the event of an instance or zone failure, this configuration…

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

How the community answered

(21 responses)

A
71% (15)
B
19% (4)
C
5% (1)
D
5% (1)

Explanation

high availability (HA) configuration for Cloud SQL instances... A Cloud SQL instance configured for HA is also called a regional instance and is located in a primary and secondary zone within the configured region.In the event of an instance or zone failure, this configuration reduces downtime, and your data continues to be available to client applications.

Topics

#Cloud SQL#high availability#SQL Server#zonal failover

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-ARCHITECT Practice