AWS Certified Data Engineer Associate DEA-C01 Practice Question
A retail company stores sales transactions as partitioned Parquet files in Amazon S3. Business users need an interactive dashboard that refreshes daily, scales automatically without server management, and restricts each user to see only their own region's data. Which approach meets these requirements with the lowest operational overhead?
Use Amazon QuickSight connected to Amazon Athena queries on the S3 data, import results into SPICE, define row-level security, and set a daily refresh schedule.
Create an AWS Glue DataBrew project to build charts and share them with users; schedule daily dataset refresh.
Spin up an Amazon EMR cluster with Apache Zeppelin notebooks, build visualizations, and configure IAM policies for region-based access.
Load the data into an Amazon Redshift cluster and use Redshift-native dashboards with workgroup-level access controls.
Amazon QuickSight is a serverless BI service that can connect directly to Amazon Athena queries against S3 data. Importing the data into QuickSight SPICE allows scheduled daily refreshes without managing infrastructure. QuickSight also provides row-level security rules so users can be limited to the rows for their region. Creating a Redshift cluster or EMR adds unnecessary administration, and AWS Glue DataBrew is designed for data preparation, not enterprise dashboards.
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 SPICE in Amazon QuickSight?
Open an interactive chat with Bash
How does Amazon Athena work with S3 data?
Open an interactive chat with Bash
What is row-level security in Amazon QuickSight?
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 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .