Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

An Amazon Redshift fact table ingests 5 million clickstream rows per hour. The table uses EVEN distribution and a compound sort key on event_time. Most analytics dashboards retrieve individual user sessions by filtering on session_id equality. Occasional monthly reports aggregate data by event_time range. Data engineers notice that session queries now require full table scans. Which schema change will most improve session query performance with minimal impact on load time?

  • Change the distribution style to KEY on session_id and retain the existing event_time sort key.

  • Keep EVEN distribution but switch the sort key to session_id only.

  • Replace the compound sort key with an interleaved sort key on session_id and event_time.

  • Convert the table to ALL distribution and set session_id as the sort key.

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