Correct Answer: To create a standby instance in a different zone that automatically takes over if the primary instance fails
A high-availability (HA) configuration in Cloud SQL maintains a primary instance and a synchronous standby replica in a different zone of the same region, enabling automatic failov...
Correct Answer
To create a standby instance in a different zone that automatically takes over if the primary instance fails
Why This Answer Is Correct
A high-availability (HA) configuration in Cloud SQL maintains a primary instance and a synchronous standby replica in a different zone of the same region, enabling automatic failover in the event of a zonal outage.
This question evaluates your knowledge of Cloud SQL — a core concept tested in Associate Cloud Engineer. Understanding Cloud SQL is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
A financial application requires a relational database that supports high availability and automated backups. The database must be fully managed to reduce operational overhead. Which service fits these requirements?
Which Google Cloud service provides fully managed MySQL, PostgreSQL, and SQL Server databases?
How can you improve the performance of heavy READ workloads on a Cloud SQL instance?
Which Cloud SQL feature allows you to connect to your database from a local machine or a VM securely without using a public IP or configuring firewall rules?
Does Cloud SQL support automatic storage increases when the disk space is running low?