Answer-first summary for fast verification
Answer: Use Bigtable
Given the requirements for handling streaming time series financial data with sub-second latency, scalability into hundreds of terabytes, and the ability to handle high write (up to 10k records per second) and read (up to 200 MB per second) throughput, Google Cloud Bigtable is the most suitable option. Bigtable is designed for large-scale, low-latency applications, offering high performance for both read and write operations. It excels in time-series data scenarios due to its ability to efficiently handle large amounts of data with consistent, low latency. Firestore is more suited for document-based data with simpler query needs, BigQuery is optimized for analytics and not for sub-second latency, and Cloud Spanner, while offering strong consistency and scalability, may not be as cost-effective or optimized for time-series data as Bigtable.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What database solution should you implement for an application that processes streaming financial time series data, requiring sub-second latency for time-based queries, scalability to hundreds of terabytes, and support for 10k writes per second and 200 MB/s read throughput?
A
Use Firestore.
B
Use Bigtable
C
Use BigQuery.
D
Use Cloud Spanner.
No comments yet.