AZ-400 · Question #520
Hotspot Question 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
The correct answer is Six columns will be returned in the query output. = Yes; The data type of the Duration column is timespan. = Yes. The KQL query uses 'extend' to add a computed column (Duration) to the existing columns in the table, and 'project' or the base table would return all original columns plus the new one - resulting in six total columns returned. The Duration column is calculated using the 'datetim
Question
Exhibits
Answer Area
- Six columns will be returned in the query output.Yes
- The data type of the Duration column is timespan.Yes
Explanation
The KQL query uses 'extend' to add a computed column (Duration) to the existing columns in the table, and 'project' or the base table would return all original columns plus the new one - resulting in six total columns returned. The Duration column is calculated using the 'datetime_diff' or subtraction of two datetime values, which in KQL produces a 'timespan' data type, confirming both statements are correct with 'Yes'.
Topics
Community Discussion
No community discussion yet for this question.