HOTSPOT
-
You have the following dataset.
You need to calculate the ranking shown in the Rank field.
How should you complete the formula? Use the dropdowns in the Answer Area to select the correct options to complete the formula.
TDA-C01 Exam QuestionsBrowse all questions from this exam
TDA-C01 Exam - Question 63
Show AnswerHide Answer
Correct Answer:
Discussion
2 commentsmnnopen
Mar 3, 2024right answer
MonBouj
May 29, 2024RANK_DENSE(SUM([Sales])) The RANK_DENSE() function calculates a dense rank based on the sum of sales for each customer. A dense rank assigns a rank to each row, even if there are duplicate values. This means that the ranks will not skip any numbers, even if there are multiple customers with the same sales amount. The RANK() function also calculates a rank based on the sum of sales, but it does not assign a rank to duplicate values. This means that the ranks may skip numbers. The RANK_MODIFIED() function calculates a rank based on the sum of sales, but it assigns a rank to duplicate values by taking into account the number of duplicate rows. This means that the ranks will not skip any numbers, but they may not be in strict numerical order. The ROW_NUMBER() function simply assigns a sequential row number to each row.