AWS Certified Data Engineer Associate DEA-C01 Practice Question
A central security account receives encrypted AWS CloudTrail files from 15 other AWS accounts in an S3 bucket partitioned by date. Auditors must perform ad-hoc SQL queries on several years of logs with no cluster administration and pay only per query scanned. Which AWS service best meets these requirements?
Amazon Redshift Spectrum querying the S3 bucket
Amazon CloudWatch Logs Insights
Amazon Athena
Amazon OpenSearch Service with the CloudTrail integration
Amazon Athena natively queries data stored in Amazon S3 by using schema-on-read SQL, requires no infrastructure to manage, and charges per amount of data scanned. CloudWatch Logs Insights cannot query objects in S3, Amazon OpenSearch Service and Amazon Redshift Spectrum would require provisioning and operating additional clusters or data catalog integrations, increasing administration overhead and cost.
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 Amazon Athena?
Open an interactive chat with Bash
What is schema-on-read in Amazon Athena?
Open an interactive chat with Bash
How does Amazon Athena differ from Amazon Redshift Spectrum?
Open an interactive chat with Bash
How does Amazon Athena charge for queries?
Open an interactive chat with Bash
What is schema-on-read in Amazon Athena?
Open an interactive chat with Bash
How does Amazon Athena integrate with AWS CloudTrail logs?
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 .