Topic 1 Question 155
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?
CREATE TABLE new_table AS SELECT * FROM old_tables;
INSERT INTO new_table SELECT * FROM old_table;
CREATE TABLE new_table (LIKE old_table);
CREATE TABLE new_table AS (SELECT * FROM old_table) WITH NO DATA;
ユーザの投票
コメント(4)
- 正解だと思う選択肢: D
D is the correct answer.
Here is why:
The AS clause allows you to define the new table's schema based on a SELECT statement.
The WITH NO DATA clause at the end explicitly tells Athena to create the table structure without copying any data.
For more information, see the "Creating an empty copy of an existing table" section in this documentation - https://docs.aws.amazon.com/athena/latest/ug/ctas-examples.html
👍 2AgboolaKun2024/11/09 Answer: D
👍 1Parandhaman_Margan2024/10/26- 正解だと思う選択肢: D
D is correct
👍 1pikuantne2024/10/31
シャッフルモード