nerdexam
Google

CLOUD-DIGITAL-LEADER · Question #67

With respect to the Core Feature of Standby Instances of Cloud SQL which one of the options is correct.?

The correct answer is C. The standby instance is used in high availability to replace the primary instance when failover. Cloud SQL standby instances serve as high availability replicas that automatically take over when the primary instance fails during a failover event.

Google Cloud Database Services

Question

With respect to the Core Feature of Standby Instances of Cloud SQL which one of the options is correct.?

Options

  • AThe standby instance is used in high availability to replace the primary instance when failover
  • BThe standby instance is used in high availability to replace the primary instance when failover
  • CThe standby instance is used in high availability to replace the primary instance when failover
  • DNone of the Above.

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    86% (25)
  • D
    7% (2)

Why each option

Cloud SQL standby instances serve as high availability replicas that automatically take over when the primary instance fails during a failover event.

AThe standby instance is used in high availability to replace the primary instance when failover

Option A is textually identical to C, making it a duplicate distractor with no distinct technical meaning.

BThe standby instance is used in high availability to replace the primary instance when failover

Option B is textually identical to C and A, serving only as a repeated distractor in this poorly structured question.

CThe standby instance is used in high availability to replace the primary instance when failoverCorrect

In Cloud SQL's high availability configuration, the standby instance is a synchronized replica of the primary instance residing in a different zone. When a failover occurs due to infrastructure failure or maintenance, Cloud SQL automatically promotes the standby instance to become the new primary, minimizing downtime. This regional redundancy is a core feature of Cloud SQL HA design.

DNone of the Above.

None of the Above is incorrect because the statement in C accurately describes the standby instance function in Cloud SQL high availability.

Concept tested: Cloud SQL high availability standby instance failover

Source: https://cloud.google.com/sql/docs/mysql/high-availability

Topics

#Cloud SQL#High Availability#Standby Instances#Failover

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full CLOUD-DIGITAL-LEADER Practice