Dell-EMC
E20-007 · Question #79
Refer to the Exhibit. You are working on creating an OLAP query that outputs several rows of with summary rows of subtotals and grand totals in addition to regular rows that may contain NULL as…
The correct answer is B. GROUPING. See the full explanation below for the reasoning.
Question
Refer to the Exhibit. You are working on creating an OLAP query that outputs several rows of with summary rows of subtotals and grand totals in addition to regular rows that may contain NULL as shown in the exhibit. Which function can you use in your query to distinguish the row from a regular row to a subtotal row?
Exhibit
Options
- ARANK
- BGROUPING
- CGROUP_ID
- DROLLUP
How the community answered
(29 responses)- A3% (1)
- B76% (22)
- C7% (2)
- D14% (4)
Community Discussion
No community discussion yet for this question.
