PCA Question 72

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A2

  Google's own documentation recommends sharding to reduce replication lag. Also no machine size is mentioned so why do we pick up 32 cores?

• 1

  Answer is: A

• Chose B2

  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.''