DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

By Microsoft · Question Mode

QuestionQ3

Prepare data

You have a KQL database containing a table named Readings.

You need to query Readings and return the results shown in the following table.

Question Image

How should you complete the query?

Select
Readings
| filter City == "Copenhagen"
| sort by Datetime
|  PrevMeterReading = prev(MeterReading), PrevTimestamp = prev(Datetime)
|  City, Area, MeterReading, Datetime, PrevMeterReading, PrevDatetime
Explanation

After sorting, prev() returns a value from the preceding row in the serialized result set. extend creates the previous-reading and previous-datetime columns, and project returns the specified columns in the required order.

Community Discussion

No comments yet. Be the first to start the discussion!