HP

HP2-N36 · Question #36

What are the advantages of a group by pipe versus a group by hash? (Select two.)

The correct answer is A. A group by pipe uses memory more efficiently. E. A group by pipe builds its entire output table in memory. See the full explanation below for the reasoning.

Question

What are the advantages of a group by pipe versus a group by hash? (Select two.)

Options

AA group by pipe uses memory more efficiently.
BA group by pipe can be processed spill to disk if the join result is large.
CA group by pipe is at least as fast as a group by hash.
DA group by pipe requires no optimization.
EA group by pipe builds its entire output table in memory.

How the community answered

(37 responses)

A
73% (27)
B
11% (4)
C
3% (1)
D
14% (5)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full HP2-N36 Practice