Bitzu

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

Single choice

Which operator returns a specified number of arbitrary rows, handy for a first look at a table?

  1. top
  2. distinct
  3. take
  4. 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.

Select all that apply

Which operators can create a new calculated column such as Duration = EndTime - StartTime?

  1. extend
  2. where
  3. project
  4. take
  5. 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

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.

Download on the App StoreGet it on Google Play

More AZ-400 topics in this module