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

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

Question #: 198
Topic #: 1

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

A data engineer created a table named cloudtrail_logs in Amazon Athena to query AWS CloudTrail logs and prepare data for audits. The data engineer needs to write a query to display errors with error codes that have occurred since the beginning of 2024. The query must return the 10 most recent errors.

Which query will meet these requirements?

A. select count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logswhere errorcode is not nulland eventtime >= '2024-01-01T00:00:00Z' group by eventname, errorcode, errormessageorder by TotalEvents desclimit 10;
B. select count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logs where eventtime >= '2024-01-01T00:00:00Z' group by eventname, errorcode, errormessage order by TotalEvents desc limit 10;
C. select count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logswhere eventtime >= '2024-01-01T00:00:00Z' group by eventname, errorcode, errormessageorder by eventname asc limit 10;
D. select count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logs where errorcode is not nulland eventtime >= '2024-01-01T00:00:00Z' group by eventname, errorcode, errormessagelimit 10;

Show Suggested Answer

Suggested Answer: A 🗳️

by 7a1d491 at Dec. 18, 2024, 11:58 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

AWSMM

1 month, 2 weeks ago

Selected Answer: A

select count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logs where errorcode is not null and eventtime >= '2024-01-01T00:00:00Z' group by eventname, errorcode, errormessage order by TotalEvents desc limit 10;

upvoted 1 times

...

Ramdi1

3 months ago

Selected Answer: A

Why Option A is Correct? ✅ WHERE errorcode IS NOT NULL → Filters out successful events, keeping only errors. ✅ AND eventtime >= '2024-01-01T00:00:00Z' → Ensures only logs from 2024 are considered. ✅ GROUP BY eventname, errorcode, errormessage → Aggregates error occurrences per event. ✅ ORDER BY TotalEvents DESC → Sorts by the number of occurrences, ensuring the most frequent errors appear first. ✅ LIMIT 10 → Returns only the 10 most recent errors.

upvoted 2 times

...

simon2133

3 months, 2 weeks ago

Selected Answer: A

A. Same as B but including filter for error code being set

upvoted 2 times

...

fnuuu

4 months ago

Selected Answer: B

Query in the Option B is correct with 'desc' order

upvoted 1 times

...

A_E_M

4 months, 3 weeks ago

Selected Answer: B

This is not the same, but it shows the important point. Descending order is the correct answer. SELECT * FROM cloudtrail_logs WHERE eventTime >= '2024-01-01' AND errorCode IS NOT NULL ORDER BY eventTime DESC LIMIT 10;

upvoted 1 times

...