Microsoft DevOps Engineer Expert AZ-400 Practice Question
You ingest guest operating system performance counters from all Windows virtual machines into a Log Analytics workspace. You must create a workbook visualization that lists every VM whose average disk queue length during the last hour has been greater than 2. Which Kusto Query Language (KQL) statement should you use to supply the data source for the workbook?
Perf | where ObjectName == "Processor" and CounterName == "% Processor Time" | where TimeGenerated > ago(1h) | summarize AvgQueue = avg(CounterValue) by Computer | where AvgQueue > 2
Perf | where ObjectName == "LogicalDisk" and CounterName == "Avg. Disk Queue Length" | where AvgQueue > 2 | summarize AvgQueue = avg(CounterValue) by Computer | where TimeGenerated > ago(1h)
Perf | where ObjectName == "LogicalDisk" and CounterName == "Avg. Disk Queue Length" | where TimeGenerated > ago(1h) | summarize AvgQueue = avg(CounterValue) by Computer | where AvgQueue > 2
Perf | where ObjectName == "PhysicalDisk" and CounterName == "Current Disk Queue Length" | where TimeGenerated > ago(1h) | summarize AvgQueue = max(CounterValue) by Computer | where AvgQueue > 2
The Perf table stores guest-level performance counters that the Log Analytics agent collects. The counter that indicates disk congestion is LogicalDisk\Avg. Disk Queue Length. To obtain one-hour data, you filter on TimeGenerated > ago(1h). The avg() aggregation of CounterValue produces the average for the chosen period, and summarize groups the calculation per Computer. Applying the threshold after the aggregation returns only the virtual machines whose average queue length exceeds 2. Alternative queries either reference the wrong object or counter, use an inappropriate aggregation, or apply filters in an order that produces a syntax error.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the Perf table in KQL and what does it store?
Open an interactive chat with Bash
What does the LogicalDisk\Avg. Disk Queue Length counter measure?
Open an interactive chat with Bash
Why is the ‘summarize’ keyword used in the KQL query and what does it do?
Open an interactive chat with Bash
Microsoft DevOps Engineer Expert AZ-400
Implement an instrumentation strategy
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .