The correct answer is A. CREATE TABLE CUSTOMERS_CLONE LIKE CUSTOMERS; .
The CREATE TABLE ... LIKE command creates a new table with the same column definitions as an existing table, but it does not copy the data from the source table.
Why A is correct:
CREATE TABLE CUSTOMERS_CLONE LIKE CUSTOMERS; creates an empty table with the same structure as CUSTOMERS.
Why the other options are incorrect:
B). CREATE TABLE ... CLONE creates a zero-copy clone of the source table, including access to the source table's existing data at the time of cloning.
C). This creates a temporary table with one column named CLONE; it does not create a table based on the structure of CUSTOMERS.
D). CREATE TABLE ... AS SELECT creates a new table and inserts the result of the query, so it copies data from CUSTOMERS.
Official Snowflake documentation reference:
Snowflake documentation explains that CREATE TABLE ... LIKE creates a new table with the same column definitions as another table, but without copying data.
Reference: Snowflake Documentation - CREATE TABLE ... LIKE; Snowflake Documentation - CREATE TABLE ... CLONE; SnowPro Core Study Guide - SQL and Snowflake Objects.