Check your knowledge - Training

1.

What is the input and output data format of each operator in a Kusto query?

String

Tabular

JSON

2.

Which operator will return a specific number of arbitrary rows of data?

take

between

contain

3.

Which operator can be used to insert new computed columns?

print

render

project

4.

Which of the following queries best answers the following question: Which types of storms caused the most property damage in the state of Texas?

StormEvents | where DamageProperty > 0 | where State == "TEXAS" | project State, EventType, DamageProperty | sort by DamageProperty

StormEvents | where DamageCrops > 0 | where State == "TEXAS" | project State, EventType, DamageCrops | sort by DamageCrops

StormEvents | where DamageProperty > 0 | where State == "FLORIDA" | where EventType contains "thunder" | project StartTime, EventType, DamageProperty

Knowledge check