AmazonAmazon
DEA-C01 · Question #208
DEA-C01 Question #208: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #208. The question stem and answer options stay visible for context.
Data Operations and Support
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?
Options
- Aselect count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logswhere
- Bselect count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logs where
- Cselect count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logswhere
- Dselect count (*) as TotalEvents, eventname, errorcode, errormessage from cloudtrail_logs where
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SQL Querying#Amazon Athena#AWS CloudTrail#Log Analysis