Exam DP-700 topic 3 question 4 discussion

NO, YES, YES First row will be Washington, Contoso, 400 Fabrikam in Seattle will have 2 because row_rank_dense allows ties Yes, in both cases it will be 1

NO, YES, YES Location Company UnitsSold Rank Washington DC Contoso 400 1 Washington DC Litware 300 2 Seattle Contoso 300 1 Seattle Litware 100 2 Seattle Fabrikam 100 2 San Francisco Relecloud 500 1 San Francisco Litware 500 1 New York Litware 1000 1 New York Contoso 300 2 New York Relecloud 300 2 New York Fabrikam 200 3

No Yes Yes

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

NO,YES,YES Sorted and Ranked Output: Location Company UnitsSold Rank Washington DC Contoso 400 1 Washington DC Litware 300 2 Seattle Contoso 300 1 Seattle Litware 100 2 Seattle Fabrikam 100 2 San Francisco Relecloud 500 1 San Francisco Litware 500 1 New York Litware 1000 1 New York Contoso 300 2 New York Relecloud 300 2 New York Fabrikam 200 3

No, No, Yes Rows with the same UnitsSold value share the same rank

NO, YES, YES

All the answers are wrong. The correct answers are no, yes, yes: datatable(Location:string, Company:string, UnitsSold:long) [ "New York", "Contoso", 300, "New York", "Litware", 1000, "New York", "Relecloud", 300, "New York", "Fabrikam", 200, "Seattle", "Contoso", 300, "Seattle", "Litware", 100, "Seattle", "Fabrikam", 100, "San Francisco", "Relecloud", 500, "San Francisco", "Litware", 500, "Washington DC", "Litware", 300, "Washington DC", "Contoso", 400 ] | sort by Location desc, UnitsSold desc | extend Rank = row_rank_dense(UnitsSold, prev(Location) != Location)

No, Yes, Yes Company is not part of ranking in this case.

No, Yes Yes

No-Yes-No Litware from New York will be displayed at the top of the result (N) Sorting prioritizes Location in descending order, so rows from locations like "Washington DC" or "San Francisco" will appear before "New York." Thus, Litware from New York will not be at the top. Fabrikam in Seattle will have value = 2 in the Rank column (Y) Within the "Seattle" location, Fabrikam and Litware both have UnitsSold = 100. These rows are tied, and row_rank_dense assigns both a rank of 2 because dense ranking skips no numbers. Litware in San Francisco will have the same value in the Rank column as Litware in New York (N) The row_rank_dense function assigns ranks independently for each Location. "Litware" in San Francisco and "Litware" in New York belong to different partitions and will have different ranks.

No Yes No

N̈o No YEs