Question

A data engineer is building a Gold-layer report that ranks products by total revenue within each category. Two products in the 'Electronics' category tie for second place with identical revenue. The business requires that the product immediately after the tie receives rank 3 (no gaps skipped). Which window function should the engineer use in the Spark SQL query?

Accepted Answer

DENSE_RANK() OVER (PARTITION BY category ORDER BY total_revenue DESC)

Answer

RANK() OVER (PARTITION BY category ORDER BY total_revenue DESC)

Answer

ROW_NUMBER() OVER (PARTITION BY category ORDER BY total_revenue DESC)

Answer

NTILE(3) OVER (PARTITION BY category ORDER BY total_revenue DESC)