HP
HP2-N36 · Question #36
HP2-N36 Question #36: Real Exam Question with Answer & Explanation
Sign in or unlock HP2-N36 to reveal the answer and full explanation for question #36. The question stem and answer options stay visible for context.
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.
Unlock HP2-N36 to see the answer
You've previewed enough free HP2-N36 questions. Unlock HP2-N36 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.