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

Question

A data engineer needs to create an Amazon Athena table based on a subset of data from an existing Athena table named cities_world. The cities_world table contains cities that are located around the world. The data engineer must create a new table named cities_us to contain only the cities from cities_world that are located in the US. Which SQL statement should the data engineer use to meet this requirement?

Accepted Answer

Correct answer: A. The correct answer is A. Option A: INSERT INTO cities_usa (city,state) SELECT city, state FROM cities_world WHERE country=’usa’;.

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