AWS Certified Data Engineer Associate DEA-C01 Practice Question
An AWS Glue ETL job writes driver logs to the log group /aws-glue/jobs/output in JSON format. Each log event contains the fields level, message, and jobRunId. You must use CloudWatch Logs Insights to quickly show a count of unique jobRunId values that logged the string "ERROR TimeoutException" during the last 24 hours, while minimizing query cost. Which query meets these requirements?
filter message like /ERROR TimeoutException/ | stats count(jobRunId)
fields message, jobRunId | filter message like /ERROR TimeoutException/ | stats count_distinct(jobRunId) as affectedRuns
The correct query filters on the exact error text, selects only the required fields (message and jobRunId), and then uses count_distinct(jobRunId) to report the number of affected job runs in a single pass. Alternative queries either count every matching event instead of distinct jobRunId values, apply sort or limit before aggregation (which can omit relevant events and add processing overhead), or aggregate the wrong field.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is CloudWatch Logs Insights?
Open an interactive chat with Bash
What does count_distinct(jobRunId) do in CloudWatch Logs Insights?
Open an interactive chat with Bash
How does filtering with message like /ERROR TimeoutException/ work?
Open an interactive chat with Bash
AWS Certified Data Engineer Associate DEA-C01
Data Operations and Support
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .