Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

An online brokerage maintains a 120-TB Amazon Redshift data warehouse on DS2 nodes. Most queries analyze the latest 6 months of data, but analysts occasionally run reports across the full 8-year history. Leadership wants to cut storage costs, keep all data online without unload or reload tasks, and retain sub-second performance on recent data. Which Amazon Redshift approach satisfies these requirements most cost-effectively?

  • Convert the fact tables to interleaved sort keys so that queries on recent partitions scan fewer blocks.

  • Migrate the cluster to RA3 nodes and rely on Amazon Redshift managed storage to automatically tier cold data to Amazon S3.

  • Enable concurrency scaling on the existing DS2 cluster to add transient compute capacity during peak reporting hours.

  • Keep the DS2 cluster but unload all data older than 6 months to Amazon S3 and query it through Redshift Spectrum.

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