Exam DP-203 topic 2 question 27 discussion

Actual exam question from Microsoft's DP-203

Question #: 27
Topic #: 2

You have an Azure Stream Analytics job that receives clickstream data from an Azure event hub.
You need to define a query in the Stream Analytics job. The query must meet the following requirements:
✑ Count the number of clicks within each 10-second window based on the country of a visitor.
✑ Ensure that each click is NOT counted more than once.
How should you define 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)

Show Suggested Answer

Suggested Answer: B 🗳️

by Gowthamr02 at June 11, 2021, 10:46 a.m.

Comments

Submit Cancel

saty_nl

Highly Voted 2 years, 11 months ago

Correct answer.

upvoted 25 times

...

GameLift

Highly Voted 2 years, 9 months ago

keyword : do not overlap

upvoted 5 times

1 year, 8 months ago

A,C are excluded easily by the AVG function, the D also excluded by the session size that is less the window size and this will result in overlapped windows. B is left alone Hahaha just want to describe a different method to answer exam questions.

upvoted 4 times

...