HOTSPOT -
You have an Azure Stream Analytics job named ASA1.
The Diagnostic settings for ASA1 are configured to write errors to Log Analytics.
ASA1 reports an error, and the following message is sent to Log Analytics.
You need to write a Kusto query language query to identify all instances of the error and return the message field.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Box 1: DataErrorType -
The DataErrorType is InputDeserializerError.InvalidData.
Box 2: Message -
Retrieve the message.
Reference:
https://docs.microsoft.com/en-us/azure/stream-analytics/data-errors
Should be parse_json(properties_s).DataErrorType and parse_json(properties_s).Message Example: https://github.com/MicrosoftDocs/LogAnalyticsExamples/blob/master/ResourceTypes/StreamAnalytics/List-all-input-deserialization-errors.txt
as quoted, this is the appropriate answer
Oh thank Christ. When I revealed their answer I was about to explode
with documents you provide, it shows first need .DataErrorType but after project TimeGenerated, we don't need to .Message. So, thank you for the good link, for second dropdown I will go for just Message.
You should use the parse_json function https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-job-diagnostic-logs
Given Answer is correct: No need to user parse_json function. https://docs.microsoft.com/en-us/azure/stream-analytics/media/stream-analytics-job-diagnostic-logs/logs-example.png
... the link you provided shows a parse_json function