Answer-first summary for fast verification
Answer: EXPLAIN ANALYZE SELECT * FROM sales;
Option C is CORRECT because running the EXPLAIN ANALYZE SELECT * FROM sales; statement in Amazon Athena provides a detailed execution plan along with the computational cost of each operation in the SQL query. This helps the data engineer understand how the query is executed and identify any potential performance bottlenecks.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 30/60
A data engineer wants to improve the performance of SQL queries in Amazon Athena that run against a sales data table.
The data engineer wants to understand the execution plan of a specific SQL statement. The data engineer also wants to see the computational cost of each operation in a SQL query.
Which statement does the data engineer need to run to meet these requirements?
A
EXPLAIN SELECT * FROM sales;
B
EXPLAIN ANALYZE FROM sales;
C
EXPLAIN ANALYZE SELECT * FROM sales;
D
EXPLAIN FROM sales;
No comments yet.