AWS Certified Data Engineer Associate DEA-C01 Practice Question

The analytics team uses an 8-node Amazon Redshift DC2.large cluster to run ad-hoc reports against a 500-GB star schema that grows by about 10 GB per day. During business hours roughly 20 concurrent queries now finish in 2 minutes instead of 5 seconds. Management wants sub-10-second response times without doubling the monthly cost. Which solution best meets these requirements?

  • Resize the cluster to eight DC2.8xlarge nodes to increase CPU, memory, and local SSD storage.

  • Replace the cluster with Amazon RDS for PostgreSQL and create four read replicas for parallel query processing.

  • Unload the tables to Amazon S3 in Parquet format and switch the reports to query the data with Amazon Athena.

  • Migrate the cluster to RA3 nodes of similar compute size, enable Concurrency Scaling, and allow Amazon Redshift Managed Storage to hold the historical data.

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.

Bash, the Crucial Exams Chat Bot
AI Bot