AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 155

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?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: CREATE TABLE new_table AS (SELECT * FROM old_table) WITH NO DATA;.

AWS Certified Data Engineer - Associate DEA-C01 — Question 155