Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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."
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.
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
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
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.
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
high availability for cloud SQL does not guarantee the availability in the case a full zone fails because failover is managed within the same zone.
So answer is D.
B cause Cloud SQL HA its zonal and: https://cloud.google.com/sql/docs/mysql/high-availability?hl=es-419 and C its incorrect cause you put the HA in ZONES of the SAME REGION
The correct answer is A and the link is below. Bottomline is that SQL and HA is split across 2 zones
https://hevodata.com/learn/cloud-sql-high-availability/
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, 2 months agodiluviouniv
2 years, 9 months agolearningpv
4 years, 2 months agoJos
4 years, 2 months agocetanx
3 years, 9 months agomrealtor
2 years agotycho
1 year, 8 months agoAmitAr
1 year, 11 months agoSMS
Highly Voted 4 years, 1 month agoMarkosMuche
Most Recent 6 days, 6 hours agoedoo
2 months, 1 week agoPime13
3 months agoTeckexam
3 months agocfigueiredo
3 months, 1 week agocobistany
3 months, 2 weeks agoRoro_Brother
4 months, 1 week ago02fc23a
5 months agolucaluca1982
5 months, 1 week agonideesh
5 months, 2 weeks agojrisl1991
6 months, 2 weeks agoArun_m_123
6 months, 2 weeks agolisabisa
7 months agomarcohol
7 months agoduzapo
7 months, 2 weeks agoMurtuza
7 months, 3 weeks ago