Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

A company stores clickstream events in an Amazon Redshift table that ingests millions of new rows every few minutes. Analysts need a pre-aggregated summary that is available no more than 15 minutes after data lands, and the data engineering team wants to avoid operating external ETL jobs. Which Amazon Redshift feature should the team use to meet these requirements with the least operational overhead?

  • Unload new rows to Amazon S3 on a 15-minute schedule and query the aggregated data through Amazon Redshift Spectrum external tables.

  • Define a standard view on the events table and rely on Amazon Redshift result caching for fast reads.

  • Schedule an AWS Glue Spark job every 15 minutes to aggregate the data and insert the results back into Amazon Redshift.

  • Create a materialized view on the events table and enable AUTO REFRESH to incrementally maintain the aggregation.

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