Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A data engineer is looking to create a new table from various data sources and apply some transformations to the data in a single step, without altering the original data. Which SQL command is most suitable for this purpose?
A
MERGE INTO
B
UPDATE
C
INSERT INTO
D
ALTER TABLE
E
CREATE TABLE AS SELECT (CTAS)
