Ultimate access to all questions.
You are developing a stream processing solution for a logistics company that requires processing GPS data from delivery vehicles in real-time. The data is received through Azure Event Hubs and you need to use Stream Analytics to create windowed aggregates for analyzing delivery routes. 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.