Topic 1 Question 198
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?
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;
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;
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;
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;
ユーザの投票
コメント(3)
- 正解だと思う選択肢: 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;👍 1A_E_M2025/01/22 - 正解だと思う選択肢: B
Query in the Option B is correct with 'desc' order
👍 1fnuuu2025/02/11 - 正解だと思う選択肢: A
A. Same as B but including filter for error code being set
👍 1simon21332025/03/01
シャッフルモード