At CoreTrack Systems , you are tasked with selecting a suitable database solution to store time series data — specifically CPU and memory usage metrics — collected at 1-second intervals from millions of machines . The data will be queried frequently by analysts for real-time, ad hoc analytics . Your goals are: Avoiding per-query charges Choosing a schema that supports future scalability as data grows Which database and data model should you implement?