QuestionQ30

VerifiedDesigning and planning a cloud solution architecture

Your company needs to track whether a person is present in a meeting room reserved for a scheduled meeting. There are 1,000 meeting rooms across 5 offices on 3 continents. Each room has a motion sensor that reports its status every second. Motion-detector data contains only a sensor ID and several different discrete pieces of information. Analysts will use this data along with information about account owners and office locations.

Which database type should you use?

Explanation

High-volume sensor telemetry with 1,000 devices reporting every second requires horizontal scalability and flexible schema. NoSQL databases excel at this workload, efficiently storing keyed records with discrete status attributes while supporting ad-hoc queries against reference data (account owners, locations). Relational databases impose overhead on high-velocity writes; flat files and blobstores are not queryable.

Community Discussion

No comments yet. Be the first to start the discussion!