nerdexam
IBM

P2090-050 · Question #22

What two characteristics can be changed when using the CREATE TABLE AS (CTAS) statement to copy TableA to TableB? (Choose two.)

The correct answer is C. The distribution key of TableB. E. The order of the data stored in TableB. See the full explanation below for the reasoning.

Question

What two characteristics can be changed when using the CREATE TABLE AS (CTAS) statement to copy TableA to TableB? (Choose two.)

Options

  • AThe views on TableA.
  • BThe privileges on TableA.
  • CThe distribution key of TableB.
  • DThe materialized views on TableB.
  • EThe order of the data stored in TableB.

How the community answered

(46 responses)
  • A
    2% (1)
  • B
    9% (4)
  • C
    85% (39)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full P2090-050 Practice