Microsoft DevOps Engineer Expert AZ-400 Practice Question
You manage several Linux virtual machines that host a mission-critical app in Azure. Users report periodic latency spikes. VM insights is enabled and all VMs send data to the same Log Analytics workspace. You must write a KQL query that returns the five VMs with the highest average combined network bytes (sent plus received) during the last 30 minutes. Which query should you use?
InsightsMetrics
| where Namespace == "Processor"
| where Name == "% Processor Time"
| where TimeGenerated > ago(30m)
| summarize AvgCpu = avg(Val) by Computer
| top 5 by AvgCpu desc
Perf
| where CounterName == "Network Adapter\\Bytes Total/sec"
| where TimeGenerated > ago(30m)
| summarize AvgBps = avg(CounterValue) by Computer
| top 5 by AvgBps desc
InsightsMetrics
| where Namespace == "Network"
| where Name in ("TotalBytesTransmitted", "TotalBytesReceived")
| where TimeGenerated > ago(30m)
| summarize AvgBps = avg(Val) by Computer
| top 5 by AvgBps desc
AzureActivity
| where TimeGenerated > ago(30m)
| summarize Events = count() by Caller
| top 5 by Events desc
The InsightsMetrics table stores the performance counters that VM insights collects for Linux and Windows virtual machines. Network bandwidth is recorded in the Network namespace with the counters TotalBytesTransmitted and TotalBytesReceived. By filtering for these counters in the last 30 minutes, aggregating their values, and then using the top operator, you obtain the five virtual machines with the greatest average throughput. Queries that target the Perf table or Processor namespace do not return the required network data, and AzureActivity does not store performance metrics.
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 Log Analytics workspace in Azure?
Open an interactive chat with Bash
What is KQL and why is it important for Azure monitoring?
Open an interactive chat with Bash
What does the Namespace 'Network' represent in InsightsMetrics?
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 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .