ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam
Go to Exam

Exam DP-700 topic 2 question 9 discussion

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

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 Hide Answer
Suggested Answer: B 🗳️
by GHill1982 at Dec. 31, 2024, 6:36 p.m.

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
Submit Cancel
GHill1982
Highly Voted 3 months, 3 weeks 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 7 times
...
405a659
Highly Voted 3 months 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 5 times
...
abdulbasit170
Most Recent 2 weeks, 1 day ago
Selected Answer: B
Group by is the correct answer
upvoted 1 times
...
Loursticks1111
2 weeks, 4 days ago
Selected Answer: B
Standard Deviation is only available in Group by, not Aggregate operator
upvoted 1 times
...
MultiCloudIronMan
2 months 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 1 times
MultiCloudIronMan
2 months ago
Changed to B
upvoted 1 times
abdulbasit170
2 weeks, 1 day ago
Why did you change to B?
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago