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…

While `CREATE TABLE AS SELECT ... LIMIT 0;` can create an empty table by inferring schema from an empty result set, it uses the CTAS statement which is primarily for creating and populating tables, making `CREATE TABLE LIKE` a more explicit schema-copying command.

The `CREATE TABLE new_table LIKE existing_table;` statement is the most direct and idiomatic SQL DDL command in Amazon Athena specifically designed to create a new, empty table that replicates the schema (column names, data types, and partition keys) of an existing table without copying any data.

The syntax `CREATE TABLE new_table (LIKE existing_table);` with parentheses around `LIKE existing_table` is not a valid SQL DDL syntax for creating a table in Athena or standard SQL.

Similar to option A, `CREATE TABLE AS SELECT ... WHERE 1=0;` also uses a CTAS statement to create an empty table based on an empty result set, but `CREATE TABLE LIKE` is the dedicated DDL for schema duplication without data.