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

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

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

by TestMitch at Dec. 16, 2021, 3:59 a.m.

Comments

Submit Cancel

ANath

Highly Voted 2 years, 5 months ago

The answers are correct

upvoted 29 times

...

seba020

Highly Voted 1 year, 3 months ago

reason for "TIMESTAMPBY": https://learn.microsoft.com/en-us/stream-analytics-query/timestamp-by-azure-stream-analytics

upvoted 6 times

semauni

11 months, 1 week ago

But a TIMESTAMP BY would need an OVER clause if I see it correctly, and there is none here.

upvoted 2 times

Preksha_

7 months, 2 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 10 months ago

correct

upvoted 1 times

...

Dhaval_Azure

1 year, 3 months 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

10 months, 3 weeks 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, 11 months ago

correct answer

upvoted 2 times

...

May99

2 years, 5 months ago

I think it's system.timestamp()

upvoted 3 times

sdokmak

2 years, 1 month ago

From examples, I can only see system.timestamp() used after SELECT, not FROM.

upvoted 1 times

...

jv2120

2 years, 6 months ago

It only says about window size, not sure why tumbling window not hopping.

upvoted 2 times

Andreas_K

2 years, 6 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, 6 months ago

Correcto

upvoted 2 times

...