Google
PROFESSIONAL-DATA-ENGINEER · Question #202
You operate a database that stores stock trades and an application that retrieves average stock price for a given company over an adjustable window of time. The data is stored in Cloud Bigtable…
The correct answer is A. Change the row key syntax in your Cloud Bigtable table to begin with the stock symbol. Explanation/Reference: Timestamp at starting of rowkey causes bottleneck issues. https://cloud.google.com/bigtable/docs/schema-design-time-series#prefer_rows_to_column_versions
Submitted by zhang_li· Mar 30, 2026Designing data processing systems
Question
You operate a database that stores stock trades and an application that retrieves average stock price for a given company over an adjustable window of time. The data is stored in Cloud Bigtable where the datetime of the stock trade is the beginning of the row key. Your application has thousands of concurrent users, and you notice that performance is starting to degrade as more stocks are added. What should you do to improve the performance of your application?
Options
- AChange the row key syntax in your Cloud Bigtable table to begin with the stock symbol.
- BChange the row key syntax in your Cloud Bigtable table to begin with a random number per second.
- CChange the data pipeline to use BigQuery for storing stock trades, and update your application.
- DUse Cloud Dataflow to write summary of each day's stock trades to an Avro file on Cloud Storage.
How the community answered
(31 responses)- A65% (20)
- B10% (3)
- C6% (2)
- D19% (6)
Explanation
Explanation/Reference: Timestamp at starting of rowkey causes bottleneck issues. https://cloud.google.com/bigtable/docs/schema-design-time-series#prefer_rows_to_column_versions
Topics
#Cloud Bigtable#row key design#hotspot prevention#performance optimization
Community Discussion
No community discussion yet for this question.