Microsoft DevOps Engineer Expert AZ-400 Practice Question

The requests table stores each incoming HTTP call made to the web app and includes the timestamp, the operation name (name), and the measured duration. To limit the analysis to the last hour, you use where timestamp > ago(1h). The 95th-percentile value for the duration is calculated with summarize p95_duration=percentile(duration, 95) by name, which calculates the percentile and assigns it to a new column p95_duration. Placing the filter before summarize ensures only the desired time range is aggregated. Using the dependencies table is incorrect as it tracks outgoing calls, not incoming requests. Using avg(duration) calculates the average, not the requested 95th percentile. Filtering by timestamp after the summarize operation will cause an error because the timestamp column no longer exists after the data has been aggregated.