DP-600 Question #195: Real Exam Question with Answer & Explanation

Question

You have a Fabric workspace named Workspace1 that contains an eventstream named Eventstream1. Eventstream1 reads data from an Azure event hub named Eventhub1. Eventhub1 contains the following columns. You need to add a continuous percentile calculation to the Payload column. The solution must minimize development effort. What should you do?

Options

• AAdd a KQL queryset to Workspace1.
• BAdd a Group by transformation to Eventstream1.
• CAdd a Manage fields transformation to Eventstream1.
• DAdd an Aggregate transformation to Eventstream1.

Explanation

The Aggregate transformation in Microsoft Fabric Eventstream is designed specifically for computing windowed aggregate functions over streaming data, including statistical functions such as percentile (PERCENTILE_CONT / PERCENTILE_DISC). It lets you define a time window type (tumbling, hopping, or sliding), group columns, and apply aggregate functions - all continuously as events flow through. The Group by transformation (B) is more limited and does not expose percentile functions. The Manage fields transformation (C) only adds, removes, or renames columns. Adding a KQL queryset (A) would require routing the stream to a KQL database and writing a separate query, significantly increasing development effort compared to adding a built-in Eventstream transformation.

No community discussion yet for this question.