exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 2 question 41 discussion

Actual exam question from Microsoft's DP-203
Question #: 41
Topic #: 2
[All DP-203 Questions]

HOTSPOT -
You are designing an Azure Stream Analytics solution that receives instant messaging data from an Azure Event Hub.
You need to ensure that the output from the Stream Analytics job counts the number of messages per time zone every 15 seconds.
How should you complete the Stream Analytics query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: timestamp by -

Box 2: TUMBLINGWINDOW -
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.

Reference:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-window-functions

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
ANath
Highly Voted 2 years, 2 months ago
The answers are correct
upvoted 29 times
...
seba020
Highly Voted 1 year ago
reason for "TIMESTAMPBY": https://learn.microsoft.com/en-us/stream-analytics-query/timestamp-by-azure-stream-analytics
upvoted 6 times
semauni
8 months, 2 weeks ago
But a TIMESTAMP BY would need an OVER clause if I see it correctly, and there is none here.
upvoted 2 times
Preksha_
4 months, 3 weeks ago
As per the syntax, OVER is optional. https://learn.microsoft.com/en-us/stream-analytics-query/timestamp-by-azure-stream-analytics
upvoted 1 times
...
...
...
kkk5566
Most Recent 7 months, 1 week ago
correct
upvoted 1 times
...
Dhaval_Azure
1 year, 1 month ago
which one is correct? many question left confusing depending on discussion. and I am not trusting the answer as many answers are wrong.
upvoted 1 times
bch9994
8 months ago
you need to use the answers from ET and discussions to find the best answer yourself just like everyone on here.
upvoted 1 times
...
...
Deeksha1234
1 year, 8 months ago
correct answer
upvoted 2 times
...
May99
2 years, 3 months ago
I think it's system.timestamp()
upvoted 3 times
sdokmak
1 year, 10 months ago
From examples, I can only see system.timestamp() used after SELECT, not FROM.
upvoted 1 times
...
...
jv2120
2 years, 3 months ago
It only says about window size, not sure why tumbling window not hopping.
upvoted 2 times
Andreas_K
2 years, 3 months ago
Syntax would not be correct since hopping window expects three parameters. https://docs.microsoft.com/en-us/stream-analytics-query/hopping-window-azure-stream-analytics Tumbling window is the correct answer
upvoted 22 times
...
...
TestMitch
2 years, 4 months ago
Correcto
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