Microsoft DevOps Engineer Expert AZ-400 Practice Question
You are reviewing Application Insights data stored in the AppTraces table of an Azure Monitor Log Analytics workspace. You must write a Kusto Query Language (KQL) query that returns, for the last 24 hours, the total number of log records whose severity is Warning or higher, grouped by the cloud role (component) and sorted by the highest count first. Which query meets the requirement?
AppTraces | where TimeGenerated > ago(24h) | where SeverityLevel >= 2 | distinct Cloud_RoleName, SeverityLevel
AppTraces | where TimeGenerated > ago(24h) | summarize WarningCount = countif(SeverityLevel >= 2) | order by TimeGenerated desc
AppTraces | where TimeGenerated > ago(24h) | where SeverityLevel >= 2 | summarize WarningCount = count() by Cloud_RoleName | order by WarningCount desc
AppTraces | where TimeGenerated > ago(24h) | summarize CountPerRole = count() by Cloud_RoleName | where SeverityLevel >= 2 | order by CountPerRole desc
The correct query first restricts the time range to the most recent 24 hours with ago(24h). It then filters rows whose numeric SeverityLevel is 2 (Warning) or higher. The summarize operator counts the remaining rows per component (Cloud_RoleName). Finally, order by arranges the results in descending order of that count. The other queries either omit the severity filter, group by the wrong column, fail to aggregate correctly, or sort on the wrong field, so they do not satisfy all stated requirements.
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 Azure Monitor Log Analytics and its purpose?
Open an interactive chat with Bash
What is KQL and why is it used in Azure Monitor?
Open an interactive chat with Bash
What is the significance of the SeverityLevel column in AppTraces table?
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 .