Google Professional Cloud Database Engineer Question 236
Single answerGoogle Cloud PlatformYour company runs a mission-critical application that uses a database hosted on Google Cloud. The database must have high availability (HA) with minimal downtime and automatic failover in case of a primary instance failure. Which of the following solutions should you implement to meet these requirements?
- A
Configure a Cloud SQL instance with high availability by enabling the HA configuration.
- B
Deploy a standalone Compute Engine instance running a database and set up snapshot backups.
- C
Use Firestore in Datastore mode for its globally distributed architecture.
- D
Set up a primary-replica configuration in Cloud SQL and perform manual failover during outages.
Show answer and explanation
Correct answer: A
Explanation
For mission-critical applications requiring high availability, enabling HA in Cloud SQL is the most appropriate solution. This configuration ensures automatic failover to a standby instance in the event of a primary instance failure, minimizing downtime and providing seamless recovery. Other options either lack automatic failover, are designed for different use cases, or require manual intervention, which results in longer downtime.
- A. Correct.
Enabling high availability (HA) in Cloud SQL automatically provisions a standby instance in a different zone and ensures automatic failover, meeting the requirements for minimal downtime and automatic recovery.
- B. Incorrect.
A standalone Compute Engine instance does not inherently provide high availability or automatic failover. Snapshots only provide backup and restore capabilities, not HA.
- C. Incorrect.
Firestore in Datastore mode is a NoSQL database designed for global distribution and scalability, but it is not suitable for traditional relational database workloads and is not explicitly configured for automatic failover in this scenario.
- D. Incorrect.
While a primary-replica configuration in Cloud SQL can provide redundancy, it does not offer automatic failover unless HA is explicitly enabled. Manual failover increases downtime and does not meet the requirements.