AZ-204 Practice Question: Monitor, troubleshoot, and optimize Azure solutions
You are monitoring an Azure Web App with Application Insights. You notice that certain requests have high server response times. You need to identify which specific database queries are causing the delays. Which Application Insights feature should you use?
⚠ Common exam trap
A common mix-up: candidates confuse the Performance blade (which shows aggregated dependency durations) with the Profiler (which provides per-request, code-level traces), leading them to choose the Performance blade when they need to identify specific slow queries rather than overall trends.
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
✓
Application Insights Profiler
Application Insights Profiler is the correct feature because it provides detailed, code-level diagnostics for requests with high server response times, including per-operation breakdowns of database query durations. It captures execution traces that show exactly which SQL queries or external calls are contributing to latency, enabling you to pinpoint the specific database queries causing delays.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Application Insights Profiler
Why this is correct
Application Insights Profiler is the correct tool because it captures detailed execution traces of requests, providing a granular view of method calls and dependency durations. It specifically instruments code paths to show the exact time spent in each operation, including the duration of individual database queries and even the specific SQL commands executed, making it ideal for pinpointing performance bottlenecks at the query level.
- ✗
Live Metrics Stream
Why it's wrong here
Live Metrics Stream offers real-time, high-level performance metrics such as request rates, response times, and failure rates, along with CPU and memory usage. While useful for immediate operational monitoring and detecting sudden shifts in application health, it aggregates data and does not provide the detailed, individual transaction traces or specific database query execution times needed to diagnose performance at a granular query level.
- ✗
Performance blade
Why it's wrong here
The Performance blade in Application Insights provides an aggregated overview of application performance, highlighting top requests, dependencies, and exceptions based on average durations and counts. While it can identify slow dependency types (e.g., SQL databases), it does not drill down to show the execution time of individual database queries within a specific request, nor does it provide the detailed call stack necessary for precise query-level optimization.
- ✗
Application Map
Why it's wrong here
Application Map provides a high-level visual representation of the components in your distributed application and their interdependencies, showing average request rates and error rates between services. Its primary purpose is to illustrate the topology and health of the system's interactions, not to provide deep insights into the execution time of individual operations within a specific dependency, such as the duration of a particular database query.
Go deeper
Related to this question
About these practice questions
One of 881 original AZ-204 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.