Google Cloud Professional Cloud Architect — Question 6

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?

Answer options

• A. Configure a Cloud SQL instance with high availability enabled.
• B. Configure a Cloud Spanner instance with a regional instance configuration.
• C. Set up SQL Server on Compute Engine, using Always On Availability Groups using Windows Failover Clustering. Place nodes in different subnets.
• D. Set up SQL Server Always On Availability Groups using Windows Failover Clustering. Place nodes in different zones.

Correct answer: A

Explanation

The correct answer is A because configuring a Cloud SQL instance with high availability ensures that the service remains operational even during zone outages. Options B, C, and D do not provide the same level of seamless failover and high availability specifically designed for SQL Server in a GCP environment.