DRAG DROP
Your company has a data visualization solution that contains a customized Microsoft Azure Stream Analytics
Solution. The solution provides data to a Microsoft Powel BI deployment.
Every 10 seconds, you need to query for instances that have more than three records.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value
may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll toview content.
NOTE: Each correct selection is worth one point.
Select and Place:
Explanation:
Box 1: TumblingWindow(second, 10)
Tumbling Windows define a repeating, non-overlapping window of time.
Example: Calculate the count of sensor readings per device every 10 seconds
SELECT sensorId, COUNT(*) AS Count
FROM SensorReadings TIMESTAMP BY time
GROUP BY sensorId, TumblingWindow(second, 10)
Box 2: [Count] >= 3
Count(*) returns the number of items in a group.
https://blogs.technet.microsoft.com/machinelearning/2015/06/01/the-azure-stream-analytics-querylanguage/