DEA-C01 · Question #166
DEA-C01 Question #166: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #166. The question stem and answer options stay visible for context.
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?
Options
- AINSERT INTO cities_usa (city,state) SELECT city, state FROM cities_world WHERE
- BMOVE city, state FROM cities_world TO cities_usa WHERE country='usa';
- CINSERT INTO cities_usa SELECT city, state FROM cities_world WHERE country='usa';
- DUPDATE cities_usa SET (city, state) = (SELECT city, state FROM cities_world WHERE
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.