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?
Click on the arrows to vote for the correct answer
A. B. C. D.D.
To set up Microsoft SQL Server on GCP with no downtime in case of a data center outage in any of the zones within a GCP region, the best option is to configure SQL Server Always On Availability Groups using Windows Failover Clustering and place nodes in different zones. The correct answer is D.
Here's why:
A. Configure a Cloud SQL instance with high availability enabled: Cloud SQL provides a managed SQL database service. You can configure Cloud SQL with high availability enabled, but high availability is limited to a single zone, which means that if there is a data center outage in the zone where your instance is running, your database will be unavailable. This option does not meet the requirement of no downtime in case of a data center outage in any of the zones within a GCP region.
B. Configure a Cloud Spanner instance with a regional instance configuration: Cloud Spanner is a globally distributed, strongly consistent database service. You can configure Cloud Spanner with a regional instance configuration, which provides high availability within a region. However, Cloud Spanner is a NoSQL database and not compatible with Microsoft SQL Server. This option does not meet the requirement of setting up Microsoft SQL Server on GCP.
C. Set up SQL Server on Compute Engine, using Always On Availability Groups using Windows Failover Clustering. Place nodes in different subnets: Compute Engine is a virtual machine service that provides infrastructure for running Windows or Linux VMs on GCP. You can set up SQL Server on Compute Engine and use Always On Availability Groups using Windows Failover Clustering to achieve high availability. However, placing nodes in different subnets does not provide protection against a data center outage in a zone within a region. If a zone goes down, all subnets within that zone will be affected. This option does not meet the requirement of no downtime in case of a data center outage in any of the zones within a GCP region.
D. Set up SQL Server Always On Availability Groups using Windows Failover Clustering. Place nodes in different zones: This option meets the requirement of no downtime in case of a data center outage in any of the zones within a GCP region. SQL Server Always On Availability Groups using Windows Failover Clustering provides high availability and automatic failover between nodes in different zones within a region. If a data center outage occurs in one zone, the other nodes in the other zones will continue to serve the requests without any downtime. This is the best option for setting up Microsoft SQL Server on GCP with high availability and no downtime in case of a data center outage in any of the zones within a GCP region.
Therefore, the correct answer is D.