Google Professional Cloud Database Engineer Question 233
Select 3Google Cloud PlatformYou are tasked with designing a highly available and scalable database architecture for an e-commerce application hosted on Google Cloud. The database must handle sudden spikes in traffic during seasonal sales and ensure zero downtime. Which of the following configurations would best meet these requirements?
- A
Use Cloud Spanner with multi-region configuration for data replication and global availability.
- B
Deploy a single Cloud SQL instance in a regional configuration with automatic backups enabled.
- C
Use Cloud Bigtable for high-throughput workloads and configure it with replication across zones.
- D
Implement Firestore in Datastore mode for global scalability with strong consistency.
- E
Deploy a highly available Redis instance using Memorystore with failover enabled.
Show answer and explanation
Correct answers: A, C, D
Explanation
To implement a highly available and scalable database in Google Cloud, you need to choose solutions that can handle traffic spikes, provide redundancy, and ensure zero downtime. Cloud Spanner's multi-region configuration, Cloud Bigtable's cross-zone replication, and Firestore in Datastore mode all meet these requirements for different use cases. Cloud SQL and Memorystore, while useful in specific scenarios, do not provide the required scale or availability guarantees for this use case.
- A. Correct.
Cloud Spanner with a multi-region configuration is designed for global availability and scalability. It provides synchronous replication across regions to ensure zero downtime.
- B. Incorrect.
A single Cloud SQL instance in a regional configuration does not provide high availability, as it lacks redundancy across zones or regions. Automatic backups primarily help with disaster recovery, not availability.
- C. Correct.
Cloud Bigtable is ideal for high-throughput workloads and can be configured with replication across zones for availability. However, it is more suited for analytical and NoSQL use cases than transactional operations.
- D. Correct.
Firestore in Datastore mode supports global scalability with strong consistency, making it well-suited for applications requiring high availability and low-latency reads and writes.
- E. Incorrect.
Memorystore for Redis with failover enabled ensures high availability, but it is a caching solution and not a primary database for transactional or analytical workloads.