Ultimate access to all questions.
You are developing a stream processing solution for a manufacturing company that requires processing sensor data from production lines in real-time. The data is received through Azure Event Hubs and you need to use Stream Analytics to create windowed aggregates for analyzing production efficiency. Describe how you would set up the Stream Analytics job to handle this scenario, including the types of windowed aggregates you would use and how you would ensure data consistency across partitions.