Dell-EMC
E20-007 · Question #79
E20-007 Question #79: Real Exam Question with Answer & Explanation
Sign in or unlock E20-007 to reveal the answer and full explanation for question #79. The question stem and answer options stay visible for context.
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
Unlock E20-007 to see the answer
You've previewed enough free E20-007 questions. Unlock E20-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.