A weather monitoring system collects temperature readings from 5,000 sensors every second. The data must be stored efficiently and queried by location and time range.
Which design decisions best suit this scenario?

Question

A weather monitoring system collects temperature readings from 5,000 sensors every second. The data must be stored efficiently and queried by location and time range. 
 Which design decisions best suit this scenario?

Answer

Use sensor ID and date as the partition key

Answer

Store each reading as a separate table

Answer

Normalize data into multiple tables

Answer

Store readings as wide rows with time as clustering column

Crowdly

A weather monitoring system collects temperature readings from 5,000 sensors eve...

Want instant access to all verified answers on moovit.vit.ac.in?