Exam AZ-400 topic 2 question 48 discussion

Actual exam question from Microsoft's AZ-400

Question #: 48
Topic #: 2

HOTSPOT
-

You are interrogating logs by using KQL.

You execute the query shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by Christian_garcia_martin at Aug. 23, 2024, 3:12 p.m.

Comments

Submit Cancel

andrey8860

Highly Voted 10 months, 2 weeks ago

I believe the answer is correct. We are having five initial columns (we are including Level here, which will be constructed from a substring) and we add Duration as well.

upvoted 9 times

fuchsm999

7 months, 1 week ago

Answer is correct Extend - Creates calculated columns and append them to the result set. https://learn.microsoft.com/en-us/kusto/query/extend-operator?view=microsoft-fabric Data type is timespan https://learn.microsoft.com/en-us/kusto/query/make-timespan-function?view=microsoft-fabric

upvoted 2 times

...

PrepAZ400

Most Recent 6 months, 2 weeks ago

Answer is correct. - 5 columns are projected, and 1 is extended. So 6 columns. - Subtract 2 datetimes gives a timespan : https://learn.microsoft.com/en-us/kusto/query/datetime-timespan-arithmetic?view=microsoft-fabric. "One can subtract (but not add) two datetime values to get a timespan value expressing their difference."

upvoted 1 times

...

MrAZ105

8 months, 1 week ago

The query you provided will return five columns in its output. Here’s a summary of those columns: StartTime: The starting time of the storm event. EndTime: The ending time of the storm event. EpisodeId: A unique identifier for the storm event. State: The state in which the storm event occurred. Level: A substring of the storm summary, capturing the first 100 characters. Thus, the output will consist of these five distinct columns.

upvoted 1 times

...

osmantaskiran

9 months ago

columns:six, duration type: timespan

upvoted 1 times

...

only_juans

10 months ago

I think the second box is datetime, the first column is StartTime

upvoted 1 times

...

Christian_garcia_martin

10 months, 2 weeks ago

For me is: Box one : Five , you already have four columns ( StartTime, EndTime, EpisodeId, State ) and extend them with Duration in line 4. Box 2 : timespan

upvoted 2 times

kalatalabnik

10 months ago

What about column Level? So I believe box one is six.

upvoted 2 times

...