AWS Certified Data Engineer Associate DEA-C01 Practice Question
While investigating unexpected data-transfer charges, a data engineer must run a CloudWatch Logs Insights query that returns the single source IP address responsible for the highest cumulative bytes in VPC Flow Logs from the last hour. The log group is /aws/vpc/flowlogs and default field names are used. Which query meets the requirement?
fields srcAddr | stats count(*) as connections by srcAddr | sort connections desc | limit 1
The query must (1) restrict the time window to the last hour, (2) aggregate the bytes field for every srcAddr, (3) sort the aggregated result in descending order, and (4) return only the top entry. The correct query satisfies all four steps by using a time filter, the stats aggregation with sum(bytes), a descending sort, and a limit of 1. The distractors use the wrong aggregation (max or count), omit aggregation completely, or sort before aggregation, so they do not identify the IP with the greatest total data transferred.
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 are VPC Flow Logs?
Open an interactive chat with Bash
How does the 'stats' command work in CloudWatch Logs Insights?
Open an interactive chat with Bash
Why is 'sum(bytes)' used in the query instead of 'max(bytes)'?
Open an interactive chat with Bash
AWS Certified Data Engineer Associate DEA-C01
Data Security and Governance
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 .