Exam TDA-C01 All QuestionsBrowse all questions from this exam
Go to Exam
Question 63

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.

    Correct Answer:

Discussion
mnnopen

right answer

MonBouj

RANK_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.