Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Professional Cloud Architect All Questions

View all questions & answers for the Professional Cloud Architect exam

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 are using Cloud SQL as the database backend for a large CRM deployment. You want to scale as usage increases and ensure that you don't run out of storage, maintain 75% CPU usage cores, and keep replication lag below 60 seconds. What are the correct steps to meet your requirements?

  • A. 1. Enable automatic storage increase for the instance. 2. Create a Stackdriver alert when CPU usage exceeds 75%, and change the instance type to reduce CPU usage. 3. Create a Stackdriver alert for replication lag, and shard the database to reduce replication time.
  • B. 1. Enable automatic storage increase for the instance. 2. Change the instance type to a 32-core machine type to keep CPU usage below 75%. 3. Create a Stackdriver alert for replication lag, and deploy memcache to reduce load on the master.
  • C. 1. Create a Stackdriver alert when storage exceeds 75%, and increase the available storage on the instance to create more space. 2. Deploy memcached to reduce CPU load. 3. Change the instance type to a 32-core machine type to reduce replication lag.
  • D. 1. Create a Stackdriver alert when storage exceeds 75%, and increase the available storage on the instance to create more space. 2. Deploy memcached to reduce CPU load. 3. Create a Stackdriver alert for replication lag, and change the instance type to a 32-core machine type to reduce replication lag.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
AWS56
Highly Voted 4 years, 10 months ago
Agree with A
upvoted 25 times
heretolearnazure
1 year, 3 months ago
Sharding database will reduce latency
upvoted 4 times
...
AzureDP900
2 years, 1 month ago
1. Enable automatic storage increase for the instance. 2. Create a Stackdriver alert when CPU usage exceeds 75%, and change the instance type to reduce CPU usage. 3. Create a Stackdriver alert for replication lag, and shard the database to reduce replication time.
upvoted 2 times
...
...
9xnine
Highly Voted 2 years, 5 months ago
Has anyone who has taken the exam recently seen any lingering questions with the Stackdriver nomenclature or is it all cloud logging, cloud monitoring, etc.?
upvoted 16 times
...
nareshthumma
Most Recent 1 month ago
Answer is: A
upvoted 1 times
...
e5019c6
11 months ago
Selected Answer: B
While I understand the doubts of selecting a 32 core machine from the start, answer A might be wrong... According to this article: https://cloud.google.com/sql/docs/mysql/instance-settings#impact ''For MySQL instances, changing either the machine type or the zone of the instance results in the instance going offline for several minutes.'' And I understand that instance type == machine type. If we switch to a PostgreSQL or SQL Server instance, similar warnings appear: PostgreSQL: ''Changing the number of CPUs or the memory size results in the instance going offline for less than 60 seconds. The total time for the changes to take effect can take several minutes.'' SQL Server: ''Changing the number of CPUs or the memory size results in the instance going offline for less than 60 seconds.''
upvoted 2 times
e5019c6
11 months ago
But I also understand that the question didn't mention anything about needing the DB to be online always, so maybe these offline times are acceptable...
upvoted 1 times
...
...
AdityaGupta
1 year, 1 month ago
Selected Answer: A
You are using Cloud SQL as the database backend for a large CRM deployment. You want to scale as usage increases and ensure that you don't run out of storage, maintain 75% CPU usage cores, and keep replication lag below 60 seconds. What are the correct steps to meet your requirements? C & D is out of question as it is talking of 75% of storage, where in question it says 75% of CPU. Option A says monitoring before before taking action and sharding will also help in reducing latency. Option B specifies specific machine type, which is not correct and also memcache which is used to recude the round trip to fetch data, it will help in reducing latency. I would prefer to go with Option A, as it is correct sequence to solve the problem.
upvoted 2 times
...
red_panda
1 year, 5 months ago
Selected Answer: A
For me is A.
upvoted 1 times
...
jfricker
1 year, 9 months ago
The correct answer is D. 1. Create a Stackdriver alert when storage exceeds 75%, and increase the available storage on the instance to create more space. 2. Deploy memcached to reduce CPU load. 3. Create a Stackdriver alert for replication lag, and change the instance type to a 32-core machine type to reduce replication lag. This approach ensures that you are able to address the three requirements specified in the question: - Monitoring storage usage and increasing storage when it exceeds 75% to avoid running out of storage. - Reducing CPU load by deploying memcached, which can be used to cache frequently-used data, offloading some of the load from the database. - Monitoring replication lag and increasing the number of cores to reduce lag.
upvoted 4 times
...
Charsoft
1 year, 11 months ago
It may be A for the simple fact that all the other answers throw in a tiny detail about 32 cores. This seems like a red herring (unnecessary details that are meant to distract), so for that reason, A is the answer.
upvoted 5 times
...
megumin
2 years ago
Selected Answer: A
A is ok
upvoted 1 times
...
AzureDP900
2 years, 1 month ago
A is right
upvoted 1 times
...
6721sora
2 years, 3 months ago
A is incorrect. because of the wording "Shard the database". How can you shard the database in Cloud SQL without causing major disruptions? Sharding is not a core feature of RDBMS. B should be correct. inspite of the mention of a fixed 32 core
upvoted 3 times
jay9114
2 years, 1 month ago
Ii Kk Kk You can shard cloudsql. Review this article - https://cloud.google.com/community/tutorials/horizontally-scale-mysql-database-backend-with-google-cloud-sql-and-proxysql#:~:text=Common%20approaches%20for%20horizontally%20scaling,with%20Cloud%20SQL%20and%20ProxySQL.
upvoted 4 times
fiercedog
1 year, 11 months ago
The article only mentions sharding as a concept, and not a solution for cloudsql.
upvoted 1 times
...
...
Deb2293
1 year, 9 months ago
https://cloud.google.com/community/tutorials/horizontally-scale-mysql-database-backend-with-google-cloud-sql-and-proxysql#:~:text=SQL%20and%20ProxySQL.-,Sharding,logic%20or%20a%20query%20router. You can shard MySQL. Answer should be A.
upvoted 4 times
...
...
mj20201
2 years, 8 months ago
Selected Answer: A
vote for A
upvoted 2 times
...
haroldbenites
2 years, 11 months ago
Go for A
upvoted 2 times
...
vincy2202
3 years ago
A is the correct answer
upvoted 2 times
...
amxexam
3 years, 2 months ago
We can directly eliminate C and D we are doing some work that is already automated. Still, I cannot make a point why not B is better than A? I believe adding memcash will give an additional boost Can someone help me point out why A is better than B?
upvoted 4 times
[Removed]
3 years, 1 month ago
Just to back up what amxexam said, here is the link on automatically increasing storage based on trend analysis: https://cloud.google.com/sql/docs/mysql/instance-settings#storage-capacity-2ndgen
upvoted 3 times
HenkH
2 years, 11 months ago
That is correct - but doc only mentions auto storage increase for this specific product (cloud SQL).
upvoted 1 times
HenkH
2 years, 1 month ago
Should read MySQl
upvoted 2 times
...
...
...
cotam
3 years, 1 month ago
I suppose B is not a better option, since it indicates 'add 32core cpu', with no info of the current usage that seems like a over-kill.
upvoted 5 times
...
Ishu_awsguy
2 years, 3 months ago
I would say only because of the below line| "You want to scale as usage increases" Line 1 Creating a 32 core machine upfront where we do not know what was the source machine cores would not be ideal . in that situation i would go with A
upvoted 4 times
...
...
MamthaSJ
3 years, 4 months ago
Answer is A
upvoted 4 times
...
areza
3 years, 5 months ago
A it is
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
Loading ...