Examkin

Question

Difficulty: EasyQuery and Analyze Application Insights Telemetry

You are analyzing application performance issues in Azure Application Insights. You need to write a Kusto Query Language (KQL) query to retrieve the timestamp, name, and duration for all requests that took longer than 2 seconds (2000 milliseconds). How should you complete the KQL query?

Answer:requests
| 【where】 duration > 2000
| 【project】 timestamp, name, duration

Answer

The query is completed by using the 'where' operator to filter records by duration, and the 'project' operator to select the specific columns for the output.
The correct operators are 'where' for filtering the records and 'project' for selecting the specific columns to output in the result.

Step-by-Step Solution

1
Identify the filtering operator to restrict records based on the duration value.
The 'where' operator is chosen to filter records where duration > 2000.
In KQL, 'where' is the correct operator for filtering rows based on a boolean condition.
2
Identify the projection operator to select the columns to return.
The 'project' operator is chosen to output 'timestamp', 'name', and 'duration'.
In KQL, 'project' is used to specify which columns should be included in the final result set.

Key Concept

Basic KQL querying structure using where and project operators for filtering and selecting data.
Rate this question

Topics

Query and Analyze Application Insights Telemetry