DEA-C01 Question #165: Real Exam Question with Answer & Explanation

Question

A data engineer needs to create a new empty table in Amazon Athena that has the same schema as an existing table named old_table. Which SQL statement should the data engineer use to meet this requirement?

Options

• ACREATE TABLE new_table AS SELECT * FROM old_tables;
• BINSERT INTO new_table SELECT * FROM old_table;
• CCREATE TABLE new_table (LIKE old_table);
• DCREATE TABLE new_table AS (SELECT * FROM old_table) WITH NO DATA;