
Ultimate access to all questions.
You have an Azure Stream Analytics job that ingests clickstream data from an Azure Event Hub. You must define a query for this job that meets the following requirements:
Count the number of clicks in each 10-second window, grouped by the visitor's country.
Ensure that every click is counted only once.
How should you complete the query?
A
SELECT Country, Avg(*) AS Average FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, SlidingWindow(second, 10)
B
SELECT Country, Count(*) AS Count FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, TumblingWindow(second, 10)
C
SELECT Country, Avg(*) AS Average FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, HoppingWindow(second, 10, 2)
D
SELECT Country, Count(*) AS Count FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, SessionWindow(second, 5, 10)