Examtopics

AWS Certified Data Engineer - Associate

88
90

Topic 1 Question 89
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?
- EXPLAIN SELECT * FROM sales;
- EXPLAIN ANALYZE FROM sales;
- EXPLAIN ANALYZE SELECT * FROM sales;
- EXPLAIN FROM sales;
ユーザの投票
コメント(3)
- 正解だと思う選択肢: C
  use EXPLAIN ANALIZE https://docs.aws.amazon.com/athena/latest/ug/athena-explain-statement.html
  
  👍 5
  FunkyFresco2024/06/20
- 正解だと思う選択肢: C
  A - Only partially meets the requirements as it does not include computational costs. B - Incorrect syntax and does not meet the requirements. C - Fully meets the requirements by providing both the execution plan and the computational costs. D - Incorrect syntax and does not meet the requirements.
  
  👍 4
  tgv2024/06/15
- 正解だと思う選択肢: C
  explain analyze + select * from table
  
  👍 1
  HunkyBunky2024/07/03
シャッフルモード

88
90