HP
HP2-N36 · Question #15
HP2-N36 Question #15: Real Exam Question with Answer & Explanation
Sign in or unlock HP2-N36 to reveal the answer and full explanation for question #15. The question stem and answer options stay visible for context.
Question
What are the advantages of a merge join versus a hash join? (Select two.)
Options
- ASometimes a merge join runs faster than a hash join.
- BA merge join uses memory more efficiently.
- CA merge join requires no optimization.
- DA merge join can spill to disk if the inner table is too large.
- EA merge join joins the data into a new projection.
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.