Scenario: You manage a network of 1,000 sensors gcp video
data-engineer-pro video for scenario: You manage a network of 1,000 sensors generating time series data. Each sensor produces one metric per second, along with
Answer
Full Certification Question
Scenario: You manage a network of 1,000 sensors generating time series data. Each sensor produces one metric per second, along with a timestamp. Currently, you have 1 TB of data, with an expected growth of 1 GB per day. You need two types of data access: Retrieve a specific metric from a particular sensor at a given timestamp with a median latency in single-digit milliseconds. Perform complex analytic queries, including joins, on the data once a day. Question: How should you store this data to meet both access requirements?