
Ultimate access to all questions.
Imagine you are managing a network of 1000 sensors, each generating time series data at the rate of one metric per sensor per second, accompanied by a timestamp. Currently, you have accumulated 1 TB of data and anticipate an increase of 1 GB daily. You require two distinct access patterns for this data:
What would be the optimal way to store this data to meet these requirements?
A
Store your data in BigQuery. Concatenate the sensor ID and timestamp, and use it as the primary key.
B
Store your data in Bigtable. Concatenate the sensor ID and timestamp and use it as the row key. Perform an export to BigQuery every day.
C
Store your data in Bigtable. Concatenate the sensor ID and metric, and use it as the row key. Perform an export to BigQuery every day.
D
Store your data in BigQuery. Use the metric as a primary key.