AZ-204 Practice Question: Monitor, troubleshoot, and optimize Azure solutions
You are using Azure Application Insights to monitor a web application. You need to create a custom dashboard that shows the number of failed requests per endpoint over the last 24 hours. Which query language should you use?
⚠ Common exam trap
Watch out — candidates often confuse Application Insights with traditional SQL-based monitoring tools, or assume that any scripting language (like Python or PowerShell) can be used directly in the Azure portal's query editor, when in fact KQL is the only supported query language for Application Insights log queries and dashboards.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Kusto Query Language (KQL)
Azure Application Insights stores telemetry data in a Log Analytics workspace, which is queried using Kusto Query Language (KQL). To create a custom dashboard showing failed requests per endpoint over the last 24 hours, you would use a KQL query that filters on 'requests' where 'success == false', then summarizes by 'cloud_RoleInstance' or 'url' using the 'summarize' operator and the 'bin' function for time intervals. KQL is the native query language for Azure Monitor and Application Insights, making it the correct choice for this scenario.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Python
Why it's wrong here
Python is a general-purpose language usable via SDKs, but Application Insights dashboards query telemetry with KQL directly. Python would be the right choice for scripting ingestion, custom metrics or automation, not for the log query powering a failed-request-per-endpoint dashboard.
- ✓
Kusto Query Language (KQL)
Why this is correct
KQL is the native query language for Azure Application Insights, Log Analytics and Monitor. Writing a KQL query against the requests table, filtered on success equals false and grouped by endpoint name, returns failed requests per endpoint over the last 24 hours, satisfying the dashboard requirement.
- ✗
SQL
Why it's wrong here
Application Insights stores telemetry in Azure Monitor Logs, queried with KQL, not T-SQL. SQL suits Azure SQL Database or Synapse relational workloads. KQL's operators such as summarize and bin directly produce the per-endpoint failure counts over the 24-hour window the dashboard requires.
- ✗
PowerShell
Why it's wrong here
PowerShell drives Azure automation and resource management, not Application Insights telemetry querying. The dashboard needs KQL (Kusto Query Language) to aggregate failed requests by endpoint over 24 hours. PowerShell would be right for scripting deployment or configuration tasks, not for authoring log analytics queries.
Go deeper
Related to this question
About these practice questions
Courseiva writes every AZ-204 question from scratch — 883 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AZ-204 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AZ-204 exam.