EMC Proven Professional – Data Science and Big Data Analytics — Question 12

When would you use GROUP BY ROLLUP clause in your OLAP query?

Answer options

• A. where all subtotals and grand totals are to be included in the output
• B. where only the subtotals are to be included in the output
• C. where only the grand totals are to be included in the output
• D. where only specific subtotals and grand totals for a combination of variables are to be included in the output

Correct answer: A

Explanation

The GROUP BY ROLLUP clause is designed to include all subtotals and the grand total in the output, making Option A the correct choice. Options B and C only provide partial information by excluding either subtotals or grand totals, while Option D limits the output by focusing on specific combinations, which does not utilize the full capability of the ROLLUP clause.