Dell-EMC

E20-007 · Question #106

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

The correct answer is D. where all subtotals and grand totals are to be included in the output. See the full explanation below for the reasoning.

Question

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

Options

Awhere only specific subtotals and grand totals for a combination of variables are to be included
Bwhere only the subtotals are to be included in the output
Cwhere only the grand totals are to be included in the output
Dwhere all subtotals and grand totals are to be included in the output

How the community answered

(49 responses)

A
10% (5)
B
6% (3)
C
4% (2)
D
80% (39)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full E20-007 Practice