Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

A company stores daily sales CSV files in Amazon S3. Business analysts need a dashboard that shows a 7-day rolling average of sales and must support ad-hoc filtering. The solution must remain fully serverless and require the least possible operational effort. Which approach meets these requirements?

  • Trigger an AWS Lambda function on each new file to compute the 7-day rolling average and store results in Amazon DynamoDB; connect Amazon QuickSight to DynamoDB for visualization.

  • Run an AWS Glue ETL job to load the files into a provisioned Amazon Redshift cluster, create a materialized view for the rolling average, and visualize it with Amazon QuickSight.

  • Create an Amazon Athena view that uses SQL window functions to calculate the 7-day rolling average, then build an Amazon QuickSight dashboard that queries the view and refreshes data into SPICE on a schedule.

  • Launch an Amazon EMR cluster with Apache Spark to pre-compute daily aggregates, write the results in Parquet format to S3, and point Amazon QuickSight to the Parquet dataset through a manifest file.

AWS Certified Data Engineer Associate DEA-C01
Data Operations and Support
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot