AZ-204 Practice Question: Monitor, troubleshoot, and optimize Azure solutions
You are monitoring an Azure Web App with Application Insights. You notice that the dependency duration for a SQL database call has significantly increased. You need to identify the specific SQL query that is causing the slowness. Which Application Insights feature should you use?
⚠ Common exam trap
A common mix-up: candidates confuse the high-level monitoring view (Application Map) or real-time streaming (Live Metrics) with the diagnostic drill-down capability of the Performance blade, which is specifically designed for root-cause analysis of slow operations.
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
✓
Performance blade and drill into Dependencies
The Performance blade in Application Insights allows you to drill into specific operations, including dependencies. By selecting the SQL dependency with increased duration, you can view the 'Dependencies' tab to see the exact SQL query text, duration, and other details. This directly identifies the slow query without needing to instrument code changes.
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 Map
Why it's wrong here
Application Map provides a high-level visual representation of your application's components and their interactions, including external dependencies like databases. While it effectively visualizes the flow and identifies problematic components with aggregate metrics such as average duration or failure rates, it does not offer the granular detail of individual SQL query texts or execution plans. Its primary purpose is architectural understanding and identifying overall system health, not deep-dive query analysis.
- ✓
Performance blade and drill into Dependencies
Why this is correct
The Performance blade within Application Insights is specifically designed to analyze the performance of various operations, including external dependencies. By navigating to the 'Dependencies' tab within this blade, users can view a comprehensive list of all dependency calls, such as SQL database interactions. Crucially, it provides detailed telemetry including the full SQL query text, average duration, call count, and success rate, enabling precise identification and investigation of slow or failing database queries.
- ✗
Live Metrics Stream
Why it's wrong here
Live Metrics Stream offers a real-time, near-instantaneous view of your application's health and performance, displaying metrics like requests, failures, and CPU usage as they occur. While it can show a sample of dependency calls in real-time, it is not designed for historical analysis or drilling down into the full text of specific slow SQL queries from past operations. Its utility lies in immediate operational awareness and quick health checks rather than detailed post-mortem performance diagnostics.
- ✗
Smart Detection
Why it's wrong here
Smart Detection in Application Insights automatically applies machine learning to your telemetry to proactively identify performance anomalies, such as sudden spikes in failure rates or performance degradation. It generates alerts and provides high-level insights into the detected issue, often pointing to the affected operation or dependency type. However, Smart Detection's role is to alert to a problem and provide initial context, not to provide the specific, detailed SQL query text required for direct troubleshooting of a slow database call.
Go deeper
Related to this question
About these practice questions
Courseiva writes every AZ-204 question from scratch — 881 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.