Google Professional Cloud Database Engineer Question 68
Single answerGoogle Cloud PlatformYour company is building a real-time analytics platform to process clickstream data from a high-traffic e-commerce website. The platform must support millions of writes per second, offer low-latency reads, and allow for horizontal scalability. Which Google Cloud database solution is most appropriate for this use case?
- A
Cloud SQL with MySQL
- B
BigQuery
- C
Cloud Spanner
- D
Firestore in Datastore mode
Show answer and explanation
Correct answer: C
Explanation
Cloud Spanner is the best choice for this scenario due to its ability to handle high write throughput, low-latency reads, and horizontal scalability. It is specifically designed to support both relational data modeling and real-time analytics, making it ideal for a high-traffic platform processing clickstream data.
- A. Incorrect.
Cloud SQL with MySQL is not suitable for this use case due to its limited scalability for high write rates and low-latency reads compared to other options.
- B. Incorrect.
BigQuery is designed for analytical workloads and is optimized for batch processing, not real-time analytics or high write throughput.
- C. Correct.
Cloud Spanner is a globally distributed relational database that supports horizontal scalability, high write throughput, and low-latency reads, making it ideal for real-time analytics on clickstream data.
- D. Incorrect.
Firestore in Datastore mode is a NoSQL database that supports high scalability but is not optimized for complex analytics or relational data modeling as required for this real-time analytics use case.