nerdexam
MicrosoftMicrosoft

DP-700 · Question #103

DP-700 Question #103: Real Exam Question with Answer & Explanation

Sign in or unlock DP-700 to reveal the answer and full explanation for question #103. The question stem and answer options stay visible for context.

Design and implement data ingestion and transformation

Question

You have a KQL database that contains a table named Readings. You need to build a KQL query to compare the MeterReading value of each row to the previous row based on the Timestamp value. A sample of the expected output is shown in the following table. How should you complete the query? To answer, drag the appropriate values the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Unlock DP-700 to see the answer

You've previewed enough free DP-700 questions. Unlock DP-700 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#KQL#Data transformation#Window functions#Lag/Previous row
Full DP-700 PracticeBrowse All DP-700 Questions