HOTSPOT You are processing streaming data from an external data provider. You have the following code segment. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/DP-700/page_97_img_1.jpg For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/DP-700/page_97_img_2.jpg

Oh wow, trickier than it looks. The answer is: No, Yes, Yes. I checked the image and that 'sort by Location desc' means Washington DC rows are first, not New York, so Litware NY can't be at the top. Fabrikam Seattle is rank 2 because it's tied with Litware for UnitsSold in Seattle (after Contoso at 300). Litware SF and Litware NY both have the highest UnitsSold in their own locations so they get the same rank (1). Open to corrections if I missed something here.

Not at the very top, Fabrikam in Seattle gets rank 2, and Litware in San Francisco matches the rank for New York. So: No, Yes, Yes.

No for the first one since Location is sorted descending, so Washington DC comes first, not New York. Fabrikam in Seattle does get rank 2 because Contoso is higher. Litware in San Francisco and New York both have rank 1 for their respective partitions. I think some might trip over the sort order here.

Question 14 - Microsoft Data Engineering DP-700 Real Exam Questions [Jan 2026 Update]

Q: 14

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.

Your Answer

Correct Answer:

LITWARE FROM NEW YORK WILL BE DISPLAYED AT THE TOP OF THE RESULT SET. CORRECT ANSWER: NO

FABRIKAM IN SEATTLE WILL HAVE VALUE = 2 IN THE RANK COLUMN. CORRECT ANSWER: YES

LITWARE IN SAN FRANCISCO WILL HAVE THE SAME VALUE IN THE RANK COLUMN AS LITWARE IN NEW YORK. CORRECT ANSWER: YES

Explanation

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

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.
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:

Litware from New York...: No. The top row is "Washington DC", "Contoso" because of the sort by Location desc.
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.
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.

References

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

Premium Access Includes

FLASH OFFER

avail 10% DISCOUNT on YOUR PURCHASE