nerdexam
HP

HP2-N36 · Question #27

Which statements are true of a projection? (Select two.)

The correct answer is B. They can contain a join condition. C. They can only be created prior to loading data. See the full explanation below for the reasoning.

Question

Which statements are true of a projection? (Select two.)

Options

  • AThey can contain a comparison predicate.
  • BThey can contain a join condition.
  • CThey can only be created prior to loading data.
  • DThey can be created at any time, either before or after data is loaded into a table.
  • EThey can contain aggregate functions.

How the community answered

(29 responses)
  • A
    7% (2)
  • B
    72% (21)
  • D
    17% (5)
  • E
    3% (1)

Community Discussion

No community discussion yet for this question.

Full HP2-N36 Practice