Exam DP-700 topic 2 question 9 discussion

Actual exam question from Microsoft's DP-700

Question #: 9
Topic #: 2

You have a Fabric workspace that contains an eventstream named Eventstream1. Eventstream1 processes data from a thermal sensor by using event stream processing, and then stores the data in a lakehouse.
You need to modify Eventstream1 to include the standard deviation of the temperature.
Which transform operator should you include in the Eventstream1 logic?

A. Expand
B. Group by
C. Union
D. Aggregate

Show Suggested Answer

Suggested Answer: B 🗳️

by GHill1982 at Dec. 31, 2024, 6:36 p.m.

Comments

Submit Cancel

GHill1982

Highly Voted 6 months, 1 week ago

Selected Answer: B

The Group by transform operator contains the Standard deviation aggregation. The Aggregate transform operator only contains Average, Max, Min and Sum aggregation.

upvoted 10 times

...

405a659

Highly Voted 5 months, 2 weeks ago

Selected Answer: B

https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/process-events-using-event-processor-editor?pivots=standard-capabilities#group-by

upvoted 7 times

...

Loursticks1111

Most Recent 3 months ago

Selected Answer: B

Standard Deviation is only available in Group by, not Aggregate operator

upvoted 2 times

...

MultiCloudIronMan

4 months, 2 weeks ago

Selected Answer: D

while Group by is useful for creating groups, it does not provide the full range of aggregate functions that Aggregate does, including the standard deviation. This is why the Aggregate operator is the correct choice.

upvoted 2 times

MultiCloudIronMan

4 months, 2 weeks ago

Changed to B

upvoted 1 times

...