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?
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?
For setting up Microsoft SQL Server on GCP with no downtime in case of a data center outage within a region, the best approach is to use SQL Server Always On Availability Groups with Windows Failover Clustering and place nodes in different zones. This setup ensures high availability by distributing the SQL Server instances across different availability zones, thus protecting against zone-level failures. This approach effectively meets the requirement of continuous availability during a data center outage in any of the zones within a GCP region.
A seems correct. "... 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."
It applies for MySQL and HA is not available for MS SQL
Yes it is available, its in beta, but when creating a "SQL Server 2017 Standard" in Cloud SQL menu you can chose single one or HA (regional).
The problem is that these questions are ancient (talking about StackDriver all the time for example, it was rebranded in 2020!!!). So unfortunately we need to think of "What did the professor think 2-4 years ago" when this question was created. Otherwise I'd say A is the best all day!
It is available, please see; https://cloud.google.com/sql/docs/sqlserver/high-availability?_ga=2.30855355.-503483612.1582800507 Also a video from Google; https://youtu.be/vMUpNoukwnM
but it says: you need to setup SQL Server
You need to set up a Microsoft SQL server. Why are we talking about Cloud SQL
and what is Cloud SQL -> a managed service for MySQL, Posrgers, and MS SQL server
D is correct. Question is - "no downtime while installing MS SQL" , not on choosing or replacing with GCP product. I agree A is good solution for this requirements.. however question is not on choosing database.. its for HA.. so I will choose D.
Answer is A. Cloud SQL supports SQL Server and selecting high availability provides automatic failover within a region.
While A would provide you HA through a regional persistent disk usage (see 1), D exactly corresponds to the requirements of this question (see 1). So it's D. 1. https://cloud.google.com/sql/docs/features#sql_server_feature_support_for 2. https://cloud.google.com/compute/docs/instances/sql-server/configure-availability
B cloud spanner is not correct. Because it supports only PostgreSQL or GoogleSQL. Option D is correct.
By elimination, seems to me like D is the correct option with a definition issue in the answer. A. Probably, this question was created when Cloud SQL wasn't fully compatible with SQL Server. Even though it is now (2023), Cloud SQL is a regional resource, and the DR strategies talk about failing over from region to region, not from zone to zone - https://cloud.google.com/sql/docs/sqlserver/intro-to-cloud-sql-disaster-recovery#overview_of_the_basic_dr_process. B. Spanner can't be used with SQL Server, so this is obviously wrong. C. Nodes in different subnets wouldn't make a difference it they all are in the same zone. While the D answer doesn't mention Compute Engine, it seems to me like a redaction issue, not like this answer was intended to exclude Compute Engine.
They have mentioned clearly in the questionm that they don't want disaster in one "zone" to create impact within a region. So its not about muti-region.. Answer is A
https://cloud.google.com/sql/docs/sqlserver/high-availability High availability feature is available in cloud SQL. We dont have to create compute instance, install SQL server and place the db and log file in group of windows compute engine machines with failover clustering. Always chose readymade services from GCP.
C or D. A can be configured only single region
The correct Answer is D, you have to select HA at config
Answer is D I checked with one of the engineer in G, he said that Cloud sql doesn't support MS sql directly. So A is wrong
Answer is A https://www.youtube.com/watch?v=vMUpNoukwnM
A: Main requirement is high availability therefore Cloud sql is the correct choice. https://cloud.google.com/blog/products/databases/managing-high-availability-with-cloud-sql-features
A for me
This configuration ensures that if one zone goes down, the other can continue serving requests, thus maintaining operations without downtime during a data center outage. Windows Failover Clustering and SQL Server Always On Availability Groups are designed to support such high availability configurations, making this the best option to achieve the management's requirement.
No, you are not correct. GCP services vs something you manage...
Definitely A. Google always favors managed services over services you manage. It is a lot of work to set up and maintain your own server.
A because of requirement: "no downtime in case of a data center outage in any of the zones within a GCP region", Spanner is for multi-region presence.
It is A, Who say D, better not to work in cloud, but yes in on premises windows servers LOL
go for A, Why not use the available option?