Ultimate access to all questions.
Your company needs to monitor the presence of individuals in meeting rooms during scheduled meetings. With 1000 meeting rooms distributed across 5 offices on 3 different continents, each room is fitted with a motion sensor. These sensors report their status every second, providing data that includes a sensor ID and various discrete pieces of information. Analysts will need to utilize this sensor data in combination with details about account owners and office locations. What type of database would be most suitable for managing and analyzing this data?
Explanation:
The best choice for managing and analyzing the sensor data collected from motion detectors in your meeting rooms is a NoSQL database. NoSQL databases are designed to handle large volumes of rapidly changing data, which is ideal for the per-second status updates coming from 1000 sensors. Additionally, NoSQL databases can efficiently manage unstructured and semi-structured data, which fits well with the type of data being collected from motion sensors. This makes option B: NoSQL the most suitable for your requirements.