Correct Answer: Write a single query file containing multiple SELECT INTO statements targeting different defined outputs
A single Stream Analytics job can output to multiple targets. This is achieved by defining multiple outputs in the job and writing a query containing multiple SELECT ... INTO ... F...
Correct Answer
Write a single query file containing multiple SELECT INTO statements targeting different defined outputs
Why This Answer Is Correct
A single Stream Analytics job can output to multiple targets. This is achieved by defining multiple outputs in the job and writing a query containing multiple SELECT ... INTO ... FROM ... statements directing data to those respective outputs.
This question evaluates your knowledge of Azure Stream Analytics — a core concept tested in Microsoft Certified: Azure IoT Developer Specialty (AZ-220). Understanding Azure Stream Analytics is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
IoT sensor data arrives in Azure IoT Hub. You need to detect when the average temperature across all sensors exceeds 75°C for any 5-minute window, and send an alert immediately when that threshold is crossed. Which Azure service should you use?
Your Stream Analytics job processes IoT Hub telemetry. You notice that out-of-order events are causing incorrect window calculations because some sensors report data with a delay of up to 10 seconds. How should you configure Stream Analytics to handle this?
You are using Stream Analytics to calculate the average temperature of a sensor over a moving 10-minute window, where a calculation is triggered every time a new event arrives. Which window type should you use?
A Stream Analytics job processing device telemetry is showing high latency and a large backlog. Which metric should you monitor, and what scaling action is appropriate?