Exam AZ-220 topic 10 question 2 discussion

Actual exam question from Microsoft's AZ-220

Question #: 2
Topic #: 10

[All AZ-220 Questions]

How should you complete the GROUP BY clause to meet the Streaming Analytics requirements?

A. GROUP BY HoppingWindow(Second, 60, 30)
B. GROUP BY TumblingWindow(Second, 30)
C. GROUP BY SlidingWindow(Second, 30)
D. GROUP BY SessionWindow(Second, 30, 60)

Show Suggested Answer

Suggested Answer: B 🗳️
Scenario: You plan to use a 30-second period to calculate the average temperature reading of the sensors.
Tumbling window functions are used to segment a data stream into distinct time segments and perform a function against them, such as the example below. The key differentiators of a Tumbling window are that they repeat, do not overlap, and an event cannot belong to more than one tumbling window.
Incorrect Answers:
A: Hopping window functions hop forward in time by a fixed period. It may be easy to think of them as Tumbling windows that can overlap, so events can belong to more than one Hopping window result set.
Reference:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-window-functions

by BoomJosh at March 24, 2021, 7:33 p.m.

Comments

Submit Cancel

BillBaits

Highly Voted 3 years, 7 months ago

As per the requirement "minimize latency between error condition and reporting", i think the correct answer should be Sliding Window, since the average is calculated each time a new message arrives, thus reducing latency. https://docs.microsoft.com/en-us/stream-analytics-query/sliding-window-azure-stream-analytics

upvoted 9 times

...