Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

An online retailer migrates its clickstream analytics to Amazon Redshift. A 3-TB click_events fact table joins with three dimension tables, each under 20 000 rows. BI queries usually filter by event_time (timestamp) and customer_id. The team must minimize inter-node shuffling during joins and keep storage costs low. Which table configuration meets these requirements?

  • Define click_events with DISTSTYLE KEY on customer_id, define each dimension table with DISTSTYLE ALL, and set event_time as the SORTKEY on click_events.

  • Define click_events with DISTSTYLE EVEN, dimension tables with DISTSTYLE KEY on customer_id, and set customer_id as the SORTKEY for all tables.

  • Define all tables with DISTSTYLE EVEN and no sort keys.

  • Define click_events with DISTSTYLE ALL, dimension tables with DISTSTYLE EVEN, and set event_time as the SORTKEY.

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