Multiple choice technology

Suppose from a data containing marks in individual subject for every student in a class if you want to know the highest marks scored in each subject .Which component your graph must have?

  1. Sort

  2. Rollup

  3. Join

  4. Reformat

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ROLLUP is the correct component to find highest marks per subject. ROLLUP performs hierarchical aggregation and can calculate group-level maximums efficiently. You would group by subject and use a max function within ROLLUP to get the highest marks for each subject across all students.