Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

An ecommerce company uses an Amazon Redshift RA3 cluster. A BI query joins two 200-GB Redshift tables with an Aurora PostgreSQL orders table through a federated query. Grafana runs the query every minute, causing 10-second latency and high Aurora CPU. Data may be 5 minutes old, and the team wants the lowest ongoing cost. What should the data engineer do?

  • Replace the query with a standard Redshift view and rely on the query result cache for most dashboard requests.

  • Unload the two Redshift tables to Amazon S3, create external tables, and use Redshift Spectrum to join them with the federated orders table.

  • Create a materialized view that joins the Redshift and federated tables, and schedule REFRESH MATERIALIZED VIEW every 5 minutes with Amazon EventBridge. Point the dashboard to the materialized view.

  • Use AWS DMS and COPY to load the orders table into Redshift every 5 minutes, then keep the dashboard query unchanged.

AWS Certified Data Engineer Associate DEA-C01
Data Store Management
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