Examtopics

AWS Certified Data Engineer - Associate

  • Topic 1 Question 188

    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?

    • CREATE TABLE new_table - LIKE old_table;

    • CREATE TABLE new_table - AS SELECT *

      FROM old_table - WITH NO DATA;

    • CREATE TABLE new_table - AS SELECT * FROM old_table;

    • CREATE TABLE new_table - as SELECT *

      FROM old_cable - WHERE 1=1;

    シャッフルモード