A data engineer wants to improve Amazon Athena SQL query performance on a sales table and needs to inspect the execution plan and the cost of each operation for a specific query. Which statement should the engineer run?
Choose an answer
Tap an option to check your answer.
Correct answer: EXPLAIN ANALYZE SELECT * FROM sales;.
Why this is the answer
The EXPLAIN ANALYZE SELECT FROM sales; statement is the correct choice because it provides both the execution plan and the runtime statistics, including the cost of each operation, for a given query in Athena. This is crucial for performance tuning. EXPLAIN SELECT FROM sales; only shows the logical and physical plan without executing the query or providing runtime metrics. EXPLAIN ANALYZE FROM sales; and EXPLAIN FROM sales; are syntactically incorrect as they lack the SELECT keyword, which is mandatory for specifying the columns to retrieve in a SQL query.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed