Subscription1 contains a Log Analytics workspace named Workspace1. You need to show error events from the Event table. Which query should you run in Workspace1?
Choose an answer
Tap an option to check your answer.
Correct answer: search in (Event) "error".
Why this is the answer
The correct query is search in (Event) "error". This is the most straightforward way to search for a specific string within a table in Kusto Query Language (KQL), which is used by Azure Monitor Logs. The search operator performs a full-text search across all columns of the specified table. Event | where EventType is "error" is incorrect because EventType is not a standard column in the Event table in Azure Monitor Logs. Event types are typically found within columns like Level or LevelText. Also, is is not the correct operator for string comparison; == or contains would be used. select from Event where EventType == "error" uses SQL-like syntax, which is not valid KQL. KQL uses a pipe-delimited syntax for operations. Get-Event Event | where {$.EventType == "error"} uses PowerShell syntax, which is not valid for querying Log Analytics workspaces.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed