Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Location Chicago IL, USA

Exam Professional Cloud Architect topic 1 question 73 discussion

Actual exam question from Google's Professional Cloud Architect
Question #: 73
Topic #: 1
[All Professional Cloud Architect Questions]

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.
Show Suggested Answer Hide Answer

Suggested Answer: C
Reference:
https://cloud.google.com/solutions/sql-server-always-on-compute-engine

Comments

learningpv
Highly Voted 1 year, 2 months ago
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."
upvoted 13 times
learningpv
1 year, 2 months ago
It applies for MySQL and HA is not available for MS SQL
upvoted 1 times
cetanx
9 months, 1 week ago
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
upvoted 2 times
...
Jos
1 year, 2 months ago
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).
upvoted 2 times
...
...
...
SMS
Highly Voted 1 year ago
Answer is A. Cloud SQL supports SQL Server and selecting high availability provides automatic failover within a region.
upvoted 11 times
...
hasib125
Most Recent 10 hours, 19 minutes ago
As the requirement is Microsoft SQL Server on GCP and management requires - no downtime a data center outage in any of the zones within a GCP region : the solution must use 1. windows based clustering - which is "Always On Availability Groups using Windows Failover Clustering". 2. For no downtime in any of the zones within a GCP region - the clustering nodes should be on different zones. So the answer is ""D"".
upvoted 1 times
...
ahmedemad3
4 days, 11 hours ago
zone have more than one subnet so Answer is :D
upvoted 1 times
...
getzsagar
6 days, 2 hours ago
Question states you need to setup MS SQL server. Cloud SQL is a managed SQL database instance. They have not mentioned hosting a MSSQL database but have asked to setup a MSSQL server.
upvoted 2 times
...
AD3
1 week, 2 days ago
A as MS SQL Server is supported on Cloud SQL. see supported dbs https://cloud.google.com/sql/docs#docs D answer is before GCP supported MS SQL Server. https://cloud.google.com/solutions/disaster-recovery-for-microsoft-sql-server
upvoted 1 times
...
Ausias18
1 week, 4 days ago
Answer is D
upvoted 1 times
...
lynx256
2 weeks, 3 days ago
Since the middle of 2020 or so Cloud SQL includes SQL Server as well. So - for NOW, correct answer is A (see: https://cloud.google.com/sql/docs/sqlserver/high-availability). If for the exam Google checks the answers by the time they were written, more than 1 year before, IMO correct is D (we have to put instances on different ZONES).
upvoted 1 times
...
padamdha
2 weeks, 6 days ago
I guess correct Answer is A
upvoted 1 times
...
gg_robin
1 month, 2 weeks ago
I guess this question might be a bit outdates since Cloud SQL now has SQL Server available. When it comes to downtime, the only thing available in the documentation is related to a few minutes of downtime when _enabling_ HA, not for failover. I don't think Google would call this a HA setup if it would take several minutes for the actual failover to happen. I would go for A if the questions comes up on the exam.
upvoted 2 times
...
guid1984
1 month, 2 weeks ago
Correct Answer is A for MS SQL Server using Cloud SQL, you can configure HA by click of a button its a supported feature. Reference: https://cloud.google.com/sql/docs/sqlserver/configure-ha
upvoted 2 times
...
bogd
1 month, 3 weeks ago
Nowadays, Cloud SQL supports SQL Server, and HA for SQL server (https://cloud.google.com/sql/docs/sqlserver/feature_support) - with this being a fully managed service, it is definitely the right choice. I would go with A
upvoted 1 times
...
CloudGenious
1 month, 3 weeks ago
D is correct
upvoted 2 times
...
CloudGenious
1 month, 3 weeks ago
Cloud sql is not good option it provide HA but there is downtime when zone or instance fail. Cloud spanner don't support cloud sql. our req is to no downtime in zone with single region so two region not for use two region will spit the server. Ans: migrate the sql server db onto two g compute vm instance in subnet in different zone and enable sql server always on availability group which allow window failure clustering and we can make two subnet in single region .
upvoted 1 times
...
bnlcnd
2 months, 2 weeks ago
as Asure mentioned above: Answer as of 10-May-2020 is changes to A I think this question was a valid question before the SQL Server is available for HA. now, it has 2 choices. A or D. I will select A since it is more cloud native.
upvoted 2 times
...
piipo
2 months, 3 weeks ago
Answer is A.
upvoted 2 times
...
joshuaquek
3 months ago
Why isn't the answer A? Microsoft SQL Server is available on Cloud SQL and supports High Availability, according to the GCP docs: https://cloud.google.com/sql/docs/sqlserver/high-availability?_ga=2.30855355.-503483612.1582800507
upvoted 1 times
...

SaveCancel