Free Preparation Discussions
MENU
Amazon-DEA-C01 Exam - Topic 3 Question 23 Discussion
Topic #: 3
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?
A.
B.
C.
D.
Problem Analysis:
The goal is to create a new empty table in Athena with the same schema as an existing table (old_table).
The solution must avoid copying any data.
Key Considerations:
CREATE TABLE AS (CTAS) is commonly used in Athena for creating new tables based on an existing table.
Adding the WITH NO DATA clause ensures only the schema is copied, without transferring any data.
Solution Analysis:
Option A: Copies both schema and data. Does not meet the requirement for an empty table.
Option B: Inserts data into an existing table, which does not create a new table.
Option C: Creates an empty table but does not copy the schema.
Option D: Creates a new table with the same schema and ensures it is empty by using WITH NO DATA.
Final Recommendation:
Use D. CREATE TABLE new_table AS (SELECT * FROM old_table) WITH NO DATA to create an empty table with the same schema.
Fabiola
14 hours agoAlonso
6 days agoHermila
11 days agoLynelle
16 days agoDominga
21 days agoYolando
26 days agoNieves
1 month agoRebbecca
1 month agoVerlene
1 month agoDierdre
2 months agoReita
2 months agoAnnice
2 months agoTayna
2 months agoKeneth
2 months agoAleta
3 months agoXochitl
3 months agoRoselle
3 months agoOzell
3 months agoNelida
2 months ago