HOTSPOT You are processing streaming data from an external data provider. You have the following code segment. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Here is a step-by-step evaluation of the query:

1. sort by Location desc, UnitsSold desc: The table is first sorted by Location in descending alphabetical order (Washington DC, Seattle, San Francisco, New York). Within each location, it's sorted by UnitsSold in descending numerical order.
2. extend Rank=row_rank_dense(UnitsSold, prev(Location) != Location): This adds a Rank column. The row_rank_dense(Term, Restart) function assigns a rank based on the Term (UnitsSold) and restarts the rank (sets it back to 1) whenever the Restart condition (prev(Location) != Location) is true.

This query effectively partitions the data by Location and then assigns a dense rank based on UnitsSold (highest UnitsSold gets rank 1, the next highest gets 2, etc.).

Resulting Table (abbreviated):

"Washington DC", "Contoso", 400, Rank 1 "Washington DC", "Litware", 300, Rank 2 "Seattle", "Contoso", 300, Rank 1 "Seattle", "Fabrikam", 100, Rank 2 "Seattle", "Litware", 100, Rank 2 "San Francisco", "Litware", 500, Rank 1 "San Francisco", "Relecloud", 500, Rank 1 "New York", "Litware", 1000, Rank 1 "New York", "Contoso", 300, Rank 2 "New York", "Relecloud", 300, Rank 2 "New York", "Fabrikam", 200, Rank 3

Statement Analysis:

1. Litware from New York...: No. The top row is "Washington DC", "Contoso" because of the sort by Location desc.
2. Fabrikam in Seattle...: Yes. In the "Seattle" group, "Contoso" (300) gets rank 1. "Fabrikam" (100) has the next highest UnitsSold value, so it gets rank 2. "Litware" (100) shares this rank.
3. Litware in San Francisco...: Yes. "Litware in San Francisco" (500) has the highest UnitsSold for its location, getting rank 1. "Litware in New York" (1000) also has the highest UnitsSold for its location, getting rank 1.

Microsoft (Azure Data Explorer Documentation): row_rank_dense() function.

This document explains that row_rank_dense(Term, Restart) assigns a rank starting at 1. The rank increments when Term changes, and the rank restarts at 1 when the Restart expression evaluates to true. In this case, the rank restarts for each new Location.

Source: https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/row-rank-dense-function

Microsoft (Azure Data Explorer Documentation): sort operator.

This document confirms that sort by Location desc will order the locations alphabetically in reverse, placing "Washington DC" before "New York".

Source: https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/sort-operator

Microsoft (Azure Data Explorer Documentation): prev() function.

This document clarifies that prev(Location) returns the value of the Location column from the preceding row, making the expression prev(Location) != Location the condition that identifies the first row of each new location group.

Source: https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/prev-function