AWS Certified Data Engineer Associate DEA-C01 Practice Question
An e-commerce company stores its daily sales metrics as partitioned Parquet files in Amazon S3. Business analysts must build interactive dashboards that refresh hourly, support ad-hoc filtering, and must not require the data engineering team to provision or manage servers. Users are authenticated through Amazon Cognito. Which approach meets the requirements with the least operational overhead?
Create an Amazon Redshift cluster, load the Parquet data with the COPY command, and connect Amazon QuickSight in direct-query mode.
Schedule AWS Glue DataBrew jobs to generate visual charts and publish them as static HTML pages in Amazon S3.
Configure Amazon QuickSight to query the S3 data through an Athena data source, enable SPICE for hourly refreshes, and share dashboards with Cognito-authenticated users.
Launch an Amazon EMR cluster running Presto to serve the data and deploy an open-source visualization tool on Amazon ECS for analysts.
Amazon QuickSight is a fully managed, serverless BI service. It can connect to Amazon S3 data through an Athena data source, and the in-memory SPICE engine can be scheduled for hourly refreshes while still allowing analysts to perform fast, interactive filtering. Dashboards can be shared with users federated by Amazon Cognito without the team managing any infrastructure. AWS Glue DataBrew is designed for data preparation and profiling, not for hosting interactive dashboards. Creating an Amazon Redshift cluster or an Amazon EMR-based Presto query layer would satisfy the visualization need only after the team provisions, secures, and scales additional infrastructure, which contradicts the low-overhead requirement.
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.
How does Amazon Athena query data in S3?
Open an interactive chat with Bash
What is SPICE in Amazon QuickSight?
Open an interactive chat with Bash
How does Amazon Cognito integrate with QuickSight for user authentication?
Open an interactive chat with Bash
What is Amazon QuickSight and how does it work with SPICE?
Open an interactive chat with Bash
What is Amazon Athena, and why is it used as a data source with Amazon QuickSight?
Open an interactive chat with Bash
How does Amazon Cognito integrate with Amazon QuickSight for user authentication?
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 .