IBM
A2090-560 · Question #26
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
(45 responses)- A4% (2)
- B16% (7)
- C73% (33)
- D7% (3)
Community Discussion
No community discussion yet for this question.