Google Professional Cloud Database Engineer Question 230
Select 2Google Cloud PlatformYou are designing a highly scalable and available database architecture for an e-commerce application hosted on Google Cloud. The application must handle sudden traffic spikes during flash sales, minimize downtime during regional outages, and ensure data consistency across regions. Which combination of database solutions and configurations would best meet these requirements?
- A
Use Cloud Spanner with multi-region configuration to ensure global consistency and high availability.
- B
Use Cloud SQL in a single region with read replicas for scaling read operations.
- C
Implement Firestore in Datastore mode for automatic scaling and strong consistency.
- D
Use Memorystore for caching and Cloud SQL for the primary database with cross-region replicas.
- E
Deploy Bigtable in a single region with manual failover for disaster recovery.
Show answer and explanation
Correct answers: A, C
Explanation
The combination of Cloud Spanner with a multi-region configuration and Firestore in Datastore mode provides a robust solution to meet the application's requirements. Cloud Spanner ensures global availability and consistency, while Firestore offers automatic scaling and strong consistency, making them highly scalable and available solutions for an e-commerce application experiencing traffic spikes and requiring regional resilience.
- A. Correct.
Cloud Spanner with multi-region configuration is ideal for applications requiring high availability, global consistency, and scalable transactional workloads. It is designed to handle regional outages and traffic spikes effectively.
- B. Incorrect.
Cloud SQL in a single region with read replicas provides scaling for read-heavy workloads but does not meet the requirement of minimizing downtime during regional outages since it's limited to a single region.
- C. Correct.
Firestore in Datastore mode offers automatic scaling, strong consistency, and high availability, making it a suitable choice for handling traffic spikes and ensuring data durability across regions.
- D. Incorrect.
Memorystore is a caching solution and, when paired with Cloud SQL, can improve performance but does not provide the level of availability or scalability required for sudden traffic spikes and regional outages.
- E. Incorrect.
Bigtable deployed in a single region with manual failover is not suitable for minimizing downtime during regional outages. It is better suited for analytics and low-latency workloads rather than transactional e-commerce applications.