Question 820
A sales report needs the top three branches per region by aggregate revenue, including tie handling. The team implemented this change: Aggregate branch totals then apply DENSE_RANK or ROW_NUMBER as required. Which result would best confirm the change worked?
Explanation
Correct Answer
Regions show correct top branches under documented tie handling. Window ranking over preaggregated rows supports within-region top-N analysis.
Incorrect Answers
The requested metric is aggregate branch revenue; compute grouped totals before window ranking.
A per-region top-N requires PARTITION BY Region over preaggregated branch totals.
Tie policy determines whether DENSE_RANK may return more than three or ROW_NUMBER must use stable tie-breaking.