nerdexam
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

E20-007 question #79 exhibit

Options

  • ARANK
  • BGROUPING
  • CGROUP_ID
  • DROLLUP

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    76% (22)
  • C
    7% (2)
  • D
    14% (4)

Community Discussion

No community discussion yet for this question.

Full E20-007 Practice