Case Study 1 - Contoso Overview A company named Contoso, Ltd. is creating a building monitoring system that will monitor the temperature, humidity, and light level at various points in a building's…

Case Study 1 - Contoso Overview A company named Contoso, Ltd. is creating a building monitoring system that will monitor the temperature, humidity, and light level at various points in a building's internal structure. Contoso will test the system at a single building located in the United Kingdom. The building has 25 floors. Each floor has 15 rooms. Existing Environment. Current State of Development Contoso produces a set of Bluetooth sensors that read the temperature and humidity. The sensors connect to IoT gateway devices that relay the data. All the IoT gateway devices connect to an Azure IoT hub named iothub1. Existing Environment. Device Twin You plan to implement device twins by using the following JSON sample. Existing Environment. Azure Stream Analytics Each room will have between three to five sensors that will generate readings that are sent to a single IoT gateway device. The IoT gateway device will forward all the readings to iothub1 at intervals of between 10 and 60 seconds. You plan to use a gateway pattern so that each IoT gateway device will have its own IoT Hub device identity. You draft the following query, which is missing the GROUP BY clause. SELECT AVG(temperature), System.TimeStamp() AS AsaTime FROM Iothub You plan to use a 30-second period to calculate the average temperature reading of the sensors. You plan to minimize latency between the condition reported by the sensors and the corresponding alert issued by the Stream Analytics job. Existing Environment. Device Messages The IoT gateway devices will send messages that contain the following JSON data whenever the temperature exceeds a specified threshold. The level property will be used to route the messages to an Azure Service Bus queue endpoint named criticalep. Existing Environment. Issues You discover connectivity issues between the IoT gateway devices and iothub1, which cause IoT devices to lose connectivity and messages. Requirements. Planning Changes Contoso plans to make the following changes: Use Stream Analytics to process and view data. Use Azure Time Series Insights to visualize data. Implement a system to sync device statuses and required settings. Add extra information to messages by using message enrichment. Create a notification system to send an alert if a condition exceeds a specified threshold. Implement a system to identify what causes the intermittent connection issues and lost messages. Requirements. Technical Requirements Contoso must meet the following requirements: Use the built-in functions of IoT Hub whenever possible. Minimize hardware and software costs whenever possible. Minimize administrative effort to provision devices at scale. Implement a system to trace message flow to and from iothub1. Minimize the amount of custom coding required to implement the planned changes. Prevent read operations from being negatively affected when you implement additional services. How should you complete the GROUP BY clause to meet the Streaming Analytics requirements?