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?
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.
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."
Actually, although Cloud SQL offers high availability configurations, it currently doesn't support Microsoft SQL Server as one of its managed database engines. It primarily focuses on MySQL, PostgreSQL, and SQL Server (but not the full Microsoft SQL Server). And the question clearly states "you need to set up Microsoft SQL." Very tricky question. The answer is D
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
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.
A looks more relevant - Multiple zones (Highly available)
Automatic failover to another zone within your selected region. Recommended for production instances. Increases cost.
The correct approach is: D
Set up SQL Server Always On Availability Groups using Windows Failover Clustering. Place nodes in different zones.
Here’s why this is the best option:
• SQL Server Always On Availability Groups: This solution provides high availability by automatically failing over to another node in the event of a failure. It’s specifically designed for SQL Server and ensures minimal downtime in case of outages.
• Windows Failover Clustering: By configuring Windows Failover Clustering with Always On Availability Groups, you can achieve high availability by ensuring that the SQL Server can failover to another node in case of a zone or node failure.
• Placing nodes in different zones: By deploying nodes in different zones within the same region, you ensure that your setup is protected from any potential zone-level outages. If one zone experiences a failure, the other zone can take over without downtime.
The correct answer is D. Set up SQL Server Always On Availability Groups using Windows Failover Clustering. Place nodes in different zones.
Here’s why:
SQL Server Always On Availability Groups is a high-availability and disaster recovery solution for SQL Server that works across multiple zones, ensuring minimal downtime in case of a data center outage within a region.
By placing the nodes in different zones, you ensure that the database remains accessible even if one zone goes down, meeting the requirement of no downtime in case of a zone failure.
The other options are less suitable for this scenario:
A. Cloud SQL with high availability enabled would not work because Cloud SQL supports MySQL, PostgreSQL, and SQL Server but has limitations for high-availability setups with SQL Server compared to Always On Availability Groups.
B. Cloud Spanner is a Google-native distributed database solution and not directly related to SQL Server.
C mentions using different subnets, but you specifically need to place the nodes in different zones to ensure availability across multiple data centers within a region.
Thus, D is the most accurate solution for ensuring no downtime in the event of a zone failure while using Microsoft SQL Server on GCP.
Cloud SQL for SQL Server is a fully managed relational database service from Google Cloud that allows users to set up, maintain, and manage Microsoft SQL Server databases in the cloud. Cloud SQL also supports MySQL and PostgreSQL
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.
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 voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
learningpv
Highly Voted 4 years, 10 months agomrealtor
2 years, 7 months agotycho
2 years, 3 months agoRic350
3 months agodiluviouniv
3 years, 4 months agolearningpv
4 years, 10 months agoJos
4 years, 9 months agotocsa
5 months, 2 weeks agocetanx
4 years, 4 months agoAmitAr
2 years, 6 months agoSMS
Highly Voted 4 years, 8 months agongeorgiev2
Most Recent 1 week, 4 days agoSerGCP
1 week, 5 days agosim7243
1 week, 5 days agobd311b9
3 weeks agonareshthumma
1 month agoselected
4 weeks, 1 day agoJohnJamesB1212
2 months, 2 weeks agoJohnJamesB1212
2 months, 2 weeks agodesertlotus1211
3 months, 3 weeks agodesertlotus1211
3 months, 3 weeks agonhatne
4 months, 3 weeks agoccpmad
5 months, 2 weeks agohitmax87
6 months, 1 week agoMarkosMuche
7 months agoedoo
9 months, 2 weeks agoccpmad
5 months, 2 weeks agoPime13
10 months agoTeckexam
10 months, 1 week agocfigueiredo
10 months, 1 week ago