Which windowing function should you use to perform the streaming aggregation of the sales data?

A. Tumbling

B. Hopping

C. Sliding

D. Session








 

Suggested Answer: A

Scenario: The analytic process will perform aggregations that must be done continuously, without gaps, and without overlapping.
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:
B, C: Like hopping windows, events can belong to more than one sliding window.
D: Session windows can have gaps.
References:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-window-functions

This question is in DP-200 Microsoft Azure Data Engineer Exam
For getting Microsoft Certified: Azure Data Engineer Associate Certificate



Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.