DP-203 Certification Practice Question #118

Question

You are building an Azure Analytics query that will receive input data from Azure IoT Hub and write the results to Azure Blob storage.
You need to calculate the difference in the number of readings per sensor per hour.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

Despite the wording inconsistency in the prompt, the query skeleton itself is clear: it subtracts a prior reading for the same sensor from the current reading and constrains how far back to look using an hourly time bound. In Stream Analytics, that is the documented use case for `LAG(... ) OVER (PARTITION BY sensorId LIMIT DURATION(hour,1))`. The ambiguity is in the exam wording, not in the SQL pattern, so confidence is slightly reduced but still solid.

More DP-203 practice questions