Exam DP-700 Topic 2 Question 66 Discussion

Actual exam question for Microsoft's DP-700 exam
Question #: 66
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?

Suggested Answer: D Vote an answer

To compute the standard deviation of the temperature from the thermal sensor data, you would use the Aggregate transform operator in Eventstream1. The Aggregate operator allows you to apply functions like sum, average, count, and statistical functions like standard deviation across a group of rows or events. This operator is ideal for operations that require summarizing or computing statistics over a dataset, such as calculating the standard deviation.

by Pete at Mar 27, 2025, 10:12 AM

Limited Time Offer

15%

Off

Get Premium DP-700 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
r19p24
2025-06-19 22:30:22
he Aggregate transform operator in Eventstream allows you to perform statistical operations such as:

AVG(), SUM(), MIN(), MAX(), STDEV()
You typically use it with a time window or grouping, depending on how your data flows in real time.
upvoted 1 times
...
sawop70609
2025-06-18 07:31:35
Selected Answer: B
Use the Group by transformation to calculate aggregations across all events within a certain time window.
The aggregations available in the transformation are:

Average
Count
Maximum
Minimum
Percentile (continuous and discrete)
Standard Deviation
Sum
Variance


https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/process-events-using-event-processor-editor?pivots=enhanced-capabilities
upvoted 1 times
...
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.
0
0
0
10