Exam DP-700 Topic 1 Question 105 Discussion

Explanation:

Litware from New York will be displayed at the top of the result set - Yes The data is sorted first by Location in descending order and then by UnitsSold in descending order. Since " New York " is alphabetically the last Location, it will appear first in the result set. Within " New York " , Litware has the highest UnitsSold (1000), so it will be displayed at the top.
Fabrikam in Seattle will have value = 2 in the Rank column - No
The row_rank_dense function assigns dense ranks based on UnitsSold within each location. In " Seattle " :
Contoso has UnitsSold = 300 # Rank 1
Litware has UnitsSold = 100 # Rank 2
Fabrikam also has UnitsSold = 100, so it shares the same rank (2) as Litware.
Litware in San Francisco will have the same value in the Rank column as Litware in New York - No The rank is calculated separately for each location. In " San Francisco " :
Both Relecloud and Litware have UnitsSold = 500, so they share the same rank (1).
In " New York " , Litware has the highest UnitsSold = 1000 # Rank 1.
Since ranks are calculated independently for each location, Litware in San Francisco does not share the same rank as Litware in New York.