Answer-first summary for fast verification
Answer: Configure a Cloud SQL instance with high availability enabled.
The correct answer is A: Configure a Cloud SQL instance with high availability enabled. Cloud SQL supports SQL Server and provides an option to enable high availability (HA). Enabling HA ensures that the SQL Server instance will continue to operate without downtime even in the event of a zone failure within a GCP region. This is achieved by creating a secondary instance in a different zone within the same region, thus meeting the requirement for no downtime in case of a data center outage in any of the zones. Configuring Always On Availability Groups with Windows Failover Clustering (Option D) is correct but requires more effort and is not as straightforward as using the managed service provided by Cloud SQL.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are tasked with setting up Microsoft SQL Server on Google Cloud Platform (GCP). The management team has specified that the system should have no downtime in case of a data center outage in any of the zones within a GCP region. What approach should you take to meet this requirement?
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.
No comments yet.