You are a SOC Analyst working at a company that is deploying Azure Sentinel. You are in charge for performing log data analysis to search for malicious activity, display visualizations, and perform threat hunting. 
To query log data, you use the Kusto Query Language (KQL). Often a result set from a KQL statement needs to be combined or joined with another result set. You need to understand how the order of a KQL statement impacts your expected results. 
Which join comprises a row in output for every arrangement of identical rows from left and right?

Answer options:

A.kind=fullouter
B.kind=leftouter
C.kind=inner
D.kind=outer

Correct Answer: C Option C is correct. Inner contains a row in the output for every combination of matching rows from left and right.
Option B is incorrect. Leftouter contains a row for every row on the left and right, even if it has no match.
Option A is incorrect. Fullouter contains a row for every row on the left and right, even if it has no match.
Reference: 

https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/joinoperator