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

Question

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?

Accepted Answer

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

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