nerdexam
Dell-EMC

E20-007 · Question #147

How are window functions different from regular aggregate functions?

The correct answer is C. Rows retain their separate identities and the window function can access more than the current row. See the full explanation below for the reasoning.

Question

How are window functions different from regular aggregate functions?

Options

  • ARows retain their separate identities and the window function can only access the current row.
  • BRows are grouped into an output row and the window function can access more than the current row.
  • CRows retain their separate identities and the window function can access more than the current row.
  • DRows are grouped into an output row and the window function can only access the current row.

How the community answered

(31 responses)
  • A
    10% (3)
  • B
    6% (2)
  • C
    81% (25)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full E20-007 Practice