nerdexam
IBM

P2090-027 · Question #40

What type of join is the most efficient?

The correct answer is C. Collocated Join. See the full explanation below for the reasoning.

Question

What type of join is the most efficient?

Options

  • AInner join
  • BOuter join
  • CCollocated Join
  • DBroadcast join

How the community answered

(60 responses)
  • A
    12% (7)
  • B
    5% (3)
  • C
    80% (48)
  • D
    3% (2)

Community Discussion

No community discussion yet for this question.

Full P2090-027 Practice