A Data Engineer would like to create a new empty table named CURRENT_STUDENT_COPY_DATA that has the same structure as the table CURRENT_STUDENT. Which statement should be used?

The correct answer is D. CREATE TABLE current_student_copy_data LIKE current_student. CREATE TABLE ... LIKE is the correct SQL syntax for creating a new empty table that mirrors the structure (columns, data types, constraints) of an existing table - no data is copied. Options A (COPY) and B (CLONE without a semicolon) are invalid because COPY is not a DDL…

Data Movement

Question

Options

ACREATE TABLE current_student_copy_data COPY current_student;
BCREATE TABLE current_student_copy_data CLONE current_student
CCREATE TABLE current_student_copy_data CLONE current_student;
DCREATE TABLE current_student_copy_data LIKE current_student;

How the community answered

(58 responses)

A
2% (1)
B
5% (3)
C
3% (2)
D
90% (52)

Explanation

CREATE TABLE ... LIKE is the correct SQL syntax for creating a new empty table that mirrors the structure (columns, data types, constraints) of an existing table - no data is copied. Options A (COPY) and B (CLONE without a semicolon) are invalid because COPY is not a DDL keyword for this purpose, and missing the semicolon in B makes it a syntax error. Option C (CLONE) is syntactically valid in platforms like Snowflake, but CLONE performs a zero-copy clone that includes existing data - the opposite of what's needed here. The key distinction to remember is: LIKE = structure only, CLONE = structure + data. Think of it this way: you like someone's style and copy their look (structure), but you don't clone their entire existence (data).

Topics

#CREATE TABLE#DDL#Table Structure#Schema Replication

Community Discussion

No community discussion yet for this question.

Full DEA-C02 Practice