Examtopics

コメント(10)

• 正解だと思う選択肢: B

  We exclude [C[ as non ACID and [D] for being invalid (location is configured on Dataset level, not Table). Then, let's focus on "minimal human intervention in case of a failure" requirement in order to eliminate one answer among [A] and [B]. Basically, we have to compare point-in-time recovery with high availability. It doesn't matter whether it's about MySQL or PostgreSQL since both databases support those features.

  • Point-in-time recovery logs are created automatically, but restoring an instance in case of failure requires manual steps (described here: https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#perform-pitr)
  • High availability, in case of failure requires no human intervention: "If an HA-configured instance becomes unresponsive, Cloud SQL automatically switches to serving data from the standby instance." (from https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview) So answer [B] wins.
  👍 25

  NicolasN2022/11/07
• 正解だと思う選択肢: B

  B is the answer.

  https://cloud.google.com/sql/docs/postgres/high-availability#HA-configuration The purpose of an HA configuration is to reduce downtime when a zone or instance becomes unavailable. This might happen during a zonal outage, or when an instance runs out of memory. With HA, your data continues to be available to client applications.

  👍 3

  zellck2022/11/28
• 正解だと思う選択肢: B

  cloud sql with high availability enabled is enough

  👍 2

  Remi20212022/09/10