Google Professional Data Engineer Question 124
Single answerGoogle Cloud PlatformYour organization is building a real-time analytics platform for processing clickstream data from a global website. The platform needs to handle high write throughput, provide low-latency reads, and ensure scalability as data volume grows. It also requires the ability to integrate easily with BigQuery for advanced analytics. Which storage system should you choose?
- A
Cloud Bigtable
- B
Cloud SQL
- C
Cloud Storage
- D
Firestore
Show answer and explanation
Correct answer: A
Explanation
Cloud Bigtable is the best choice for real-time analytics on clickstream data due to its ability to handle high write throughput, low-latency reads, and scalability. Additionally, its integration with BigQuery makes it an excellent option for advanced analytics use cases. Other options like Cloud SQL, Cloud Storage, and Firestore are either not designed for real-time analytics or lack the required scalability and performance characteristics.
- A. Correct.
Cloud Bigtable is ideal for this scenario because it is designed for high write throughput, low-latency reads, and scalability. It integrates seamlessly with BigQuery for analytics.
- B. Incorrect.
Cloud SQL is not suitable for this use case because it is a relational database optimized for transactional workloads, not real-time analytics or high throughput.
- C. Incorrect.
Cloud Storage is better suited for object storage and is not optimized for low-latency reads or high write throughput required for real-time analytics.
- D. Incorrect.
Firestore is designed for document-based workloads and is not optimized for large-scale, high-throughput, real-time analytics scenarios.