Google Professional Cloud Database Engineer Question 176
Select 2Google Cloud PlatformYour team is designing a high-availability database architecture for a critical application on Google Cloud. You need to ensure that the application's database can handle failovers seamlessly with minimal downtime and maintain consistent data across regions. Which of the following replication strategies are most suitable for this requirement?
- A
Use Cloud Spanner's multi-region configuration to enable synchronous replication across multiple regions.
- B
Use Cloud SQL's read replicas deployed in different regions to handle failovers.
- C
Use Bigtable's replication feature to asynchronously replicate data across regions.
- D
Use Firestore's multi-region configuration for automatic replication and strong consistency.
- E
Deploy a single Cloud SQL instance in one region with automated backups for disaster recovery.
Show answer and explanation
Correct answers: A, D
Explanation
For a high-availability database architecture, you need replication strategies that ensure minimal downtime and maintain strong consistency. Cloud Spanner's multi-region configuration and Firestore's multi-region configuration both provide these guarantees. Synchronous replication in Spanner ensures consistency across regions, while Firestore's replication is automatic and strongly consistent. Other options either lack automatic failover, strong consistency, or are not suitable for such critical use cases.
- A. Correct.
Cloud Spanner's multi-region configuration is specifically designed for high availability and strong consistency across regions. It uses synchronous replication to ensure data consistency and seamless failovers.
- B. Incorrect.
While Cloud SQL's read replicas can be deployed in different regions, they are primarily intended for read scalability and do not provide automatic failover capabilities. Failover requires manual intervention.
- C. Incorrect.
Bigtable's replication is asynchronous, which can result in eventual consistency. This makes it less suitable for use cases requiring strong consistency and seamless failovers.
- D. Correct.
Firestore's multi-region configuration provides automatic replication with strong consistency, making it well-suited for high-availability scenarios where failovers are required.
- E. Incorrect.
A single Cloud SQL instance with automated backups does not provide high availability or failover capabilities. It is useful for disaster recovery but not for seamless failover.