Question 350
A sales report needs the top three branches per region by aggregate revenue, including tie handling. Initial testing shows: Regions show correct top branches under documented tie handling. Which limitation should the team still consider?
Explanation
Correct Answer
DENSE_RANK may return more than three rows when there are ties. 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.