exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 20 question 1 discussion

Actual exam question from Microsoft's DP-300
Question #: 1
Topic #: 20
[All DP-300 Questions]

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

  • A. Sliding
  • B. Hopping
  • C. Session
  • D. Tumbling
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
bingomutant
7 months ago
D. Tumbling Here's why: • Tumbling window is a fixed-size, non-overlapping window that processes the data in discrete chunks. Each event is part of exactly one window, and there are no gaps or overlaps between windows, which fits the requirement of continuous aggregation without gaps or overlaps. Other options: • Sliding window allows overlapping and could lead to redundant computations, which is not suitable for this requirement. • Hopping window can produce overlapping windows, which doesn't align with the requirement to avoid overlap. • Session window is useful for identifying periods of activity followed by inactivity, but it would not be suitable for continuous aggregation as required in this scenario.
upvoted 1 times
...
TheSwedishGuy
11 months, 3 weeks ago
DP-200 question.
upvoted 1 times
...
pjfunner
1 year ago
Azure Stream Analytics is outside the scope of the DP-300 exam
upvoted 1 times
...
Ciupaz
2 years, 7 months ago
When you see "without gaps, and without overlapping", go to Tumbling.
upvoted 2 times
...
eric0718
3 years ago
Selected Answer: D
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.
upvoted 2 times
...
xegiwo9758
3 years, 4 months ago
Selected Answer: D
The answer should be correct
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago