Answer-first summary for fast verification
Answer: CREATE TABLE new_table LIKE old_table;
Option A, `CREATE TABLE new_table LIKE old_table;`, creates an empty table with the same schema as the source table — this matches the requirement to create an *empty* copy. Option B is invalid in Athena (no `WITH NO DATA` clause). Option C copies data, which contradicts “empty copy”. Option D is syntactically incorrect and uses non-existent table `old_cable`.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 54/60
A data engineer needs to create an empty copy of an existing table in Amazon Athena to perform data processing tasks. The existing table in Athena contains 1,000 rows.
Which query will meet this requirement?
A
CREATE TABLE new_table LIKE old_table;
B
CREATE TABLE new_table AS SELECT * FROM old_table WITH NO DATA;
C
CREATE TABLE new_table AS SELECT * FROM old_table;
D
CREATE TABLE new_table AS SELECT * FROM old_cable WHERE 1=1;
No comments yet.