Exam DP-200 topic 2 question 53 discussion

Actual exam question from Microsoft's DP-200

Question #: 53
Topic #: 2

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:

Show Suggested Answer

Suggested Answer:

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

by MsIrene at April 10, 2021, 3:06 p.m.

Comments

Submit Cancel

MsIrene

Highly Voted 4 years, 1 month ago

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

upvoted 26 times

cadio30

4 years, 1 month ago

as quoted, this is the appropriate answer

upvoted 2 times

...

captainbee

3 years, 11 months ago

Oh thank Christ. When I revealed their answer I was about to explode

upvoted 2 times

...

Ati1362

3 years, 10 months ago

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.

upvoted 1 times

...

vrmei

Most Recent 4 years ago

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

upvoted 1 times

hello_there_

3 years, 11 months ago

... the link you provided shows a parse_json function

upvoted 3 times

...

Maddaa

4 years, 1 month ago

You should use the parse_json function https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-job-diagnostic-logs

upvoted 3 times

...