Google Professional Cloud Database Engineer Question 232
Single answerGoogle Cloud PlatformYour company is migrating an on-premises e-commerce application to Google Cloud. The application requires a highly scalable and available database solution to handle traffic spikes during seasonal sales events. The database must support automatic scaling, replication across multiple regions, and strong consistency. Which Google Cloud database solution should you choose to meet these requirements?
- A
Cloud Spanner
- B
Cloud SQL
- C
Firestore in Native mode
- D
BigQuery
Show answer and explanation
Correct answer: A
Explanation
Cloud Spanner is the ideal database for this scenario because it is specifically designed for highly scalable, globally distributed applications that require strong consistency and multi-region replication. It automatically scales to handle traffic spikes, making it well-suited for an e-commerce application during seasonal sales events.
- A. Correct.
Cloud Spanner is the best choice for this scenario as it is a globally distributed, highly scalable, and strongly consistent database. It supports automatic scaling, multi-region replication, and is designed for mission-critical applications.
- B. Incorrect.
Cloud SQL is a managed relational database service, but it is not designed for global scalability and multi-region replication with strong consistency. It is better suited for less demanding workloads.
- C. Incorrect.
Firestore in Native mode is a NoSQL database optimized for mobile and web applications. While it provides strong consistency and scalability, it is not ideal for relational data and e-commerce transactional systems.
- D. Incorrect.
BigQuery is a data warehouse solution optimized for analytical queries, not for handling operational transactional workloads typical in e-commerce applications.