nerdexam
Google

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #83

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…

The correct answer is B. Use Bigtable. Financial data, such as transaction histories, stock prices, and currency exchange rates. https://cloud.google.com/bigtable/docs/overview#what-its-good-for Reads - up to 10,000 rows per second Writes - up to 10,000 rows per second Scans - up to 220 MB/s…

Database Solution Design

Question

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?

Options

  • AUse Firestore.
  • BUse Bigtable
  • CUse BigQuery.
  • DUse Cloud Spanner.

How the community answered

(32 responses)
  • A
    3% (1)
  • B
    72% (23)
  • C
    16% (5)
  • D
    9% (3)

Explanation

Financial data, such as transaction histories, stock prices, and currency exchange rates. https://cloud.google.com/bigtable/docs/overview#what-its-good-for Reads - up to 10,000 rows per second Writes - up to 10,000 rows per second Scans - up to 220 MB/s https://cloud.google.com/bigtable/docs/performance#typical-workloads

Topics

#Time Series Data#Database Selection#Scalability#Bigtable

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice