QuestionQ19

VerifiedDesigning and planning a cloud solution architecture

You need to deploy Microsoft SQL Server on GCP. Management requires no downtime if a data center outage occurs in any zone within a GCP region. What should you do?

Explanation

SQL Server Always On Availability Groups use Windows Server Failover Clustering to provide automatic high availability. Placing cluster nodes in different zones within the same region isolates replicas from a zonal data-center outage, allowing a surviving replica to take over. Google Cloud documents a deployment with SQL Server cluster nodes distributed across different zones for this purpose.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!