Google Cloud Professional Cloud Database Engineer — Question 56

Your team is building an application that stores and analyzes streaming time series financial data. You need a database solution that can perform time series-based scans with sub-second latency. The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?

Answer options

• A. Use Firestore.
• B. Use Bigtable
• C. Use BigQuery.
• D. Use Cloud Spanner.

Correct answer: B

Explanation

The correct choice is B, Bigtable, as it is designed for high throughput and low latency, making it ideal for time series data. Firestore (A) is not optimized for the scale and performance required here, BigQuery (C) is more suited for analytics rather than real-time data ingestion, and Cloud Spanner (D) offers strong consistency but may not meet the specific performance needs for time series data.