nerdexam
HP

HP2-N36 · Question #43

Which statements are true about a prejoin projection? (Select three.)

The correct answer is A. A prejoin projection enforces primary and foreign key constraints. B. A prejoin projection does not increase the storage footprint. E. A prejoin projection adds no limitations to the tables in the join. See the full explanation below for the reasoning.

Question

Which statements are true about a prejoin projection? (Select three.)

Options

  • AA prejoin projection enforces primary and foreign key constraints.
  • BA prejoin projection does not increase the storage footprint.
  • CA prejoin projection slows down data loading.
  • DA prejoin projection can process any type of join.
  • EA prejoin projection adds no limitations to the tables in the join.
  • FA prejoin projection improves query run time performance.

How the community answered

(37 responses)
  • A
    73% (27)
  • C
    16% (6)
  • D
    3% (1)
  • F
    8% (3)

Community Discussion

No community discussion yet for this question.

Full HP2-N36 Practice