AZ-400 ยท Analyzing telemetry
Basic KQL queries
where, project, summarize, count, bin, order by, take, extend, join and render over tables such as requests, exceptions, traces, Heartbeat and AzureDiagnostics.
Key points
- Start with a table (requests, exceptions, traces, Heartbeat, AzureDiagnostics) and pipe operators.
- where filters, project picks columns, extend adds a calculated column.
- take: arbitrary rows; sort by / order by: descending by default; top n by: highest rows.
- count counts; summarize aggregates, often by bin(timestamp, 1h).
- join on a key like operation_Id; render draws a chart.
- Sampled data: sum(itemCount), not count().
Source: https://learn.microsoft.com/en-us/kusto/query/tutorials/learn-common-operators
Practice questions
Which operator returns a specified number of arbitrary rows, handy for a first look at a table?
- top
- distinct
- take
- count
Show answer
Answer: C. take
take returns any n rows with no ordering guarantee. top sorts first, distinct lists unique values, and count returns only a number.
Which operators can create a new calculated column such as Duration = EndTime - StartTime?
- extend
- where
- project
- take
- count
Show answer
Answer: A. extend, C. project
extend adds the calculated column to the existing ones, and project can define a computed column while keeping only the listed columns. where filters rows, take limits rows and count returns a number.
True or false: take 5 and top 5 by duration return the same rows.
Show answer
Answer: False
False. take returns any five rows with no guaranteed order, while top 5 by duration sorts by that column and returns the five highest.
Practice 8 questions on this topic in Bitzu
Short lessons, instant explanations and spaced review of what you get wrong. Free on iOS and Android.
