Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 89 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 89
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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;

Show Suggested Answer

Suggested Answer: C 🗳️

by tgv at June 15, 2024, 9:46 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

FunkyFresco

Highly Voted 10 months, 1 week ago

Selected Answer: C

use EXPLAIN ANALIZE https://docs.aws.amazon.com/athena/latest/ug/athena-explain-statement.html

upvoted 5 times

...

HunkyBunky

Most Recent 9 months, 3 weeks ago

Selected Answer: C

explain analyze + select * from table

upvoted 1 times

...

tgv

10 months, 2 weeks ago

Selected Answer: 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.

upvoted 4 times

...

Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam

Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 89 discussion

Comments

FunkyFresco

HunkyBunky

tgv

SY0-701