AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 198

Question

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?

Accepted Answer

Correct answer: A. The correct answer is A. Option 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 TotalEvent... AWS CloudTrail records API activity for auditing and governance.

AWS Certified Data Engineer - Associate DEA-C01 — Question 198