DEA-C01 · Question #104
A retail company stores transactions, store locations, and customer information tables in four reserved ra3.4xlarge Amazon Redshift cluster nodes. All three tables use even table distribution. The…
The correct answer is A. Change the distribution style of the store location table from EVEN distribution to ALL distribution. Changing the distribution style of the store location table to ALL distribution (A) is the most cost- effective solution. It directly addresses the issue of broadcasting by ensuring the entire table is available on each node, significantly improving join performance without…
Question
A retail company stores transactions, store locations, and customer information tables in four reserved ra3.4xlarge Amazon Redshift cluster nodes. All three tables use even table distribution. The company updates the store location table only once or twice every few years. A data engineer notices that Redshift queues are slowing down because the whole store location table is constantly being broadcast to all four compute nodes for most queries. The data engineer wants to speed up the query performance by minimizing the broadcasting of the store location table. Which solution will meet these requirements in the MOST cost-effective way?
Options
- AChange the distribution style of the store location table from EVEN distribution to ALL distribution.
- BChange the distribution style of the store location table to KEY distribution based on the column
- CAdd a join column named store_id into the sort key for all the tables.
- DUpgrade the Redshift reserved node to a larger instance size in the same instance family.
How the community answered
(61 responses)- A70% (43)
- B15% (9)
- C10% (6)
- D5% (3)
Explanation
Changing the distribution style of the store location table to ALL distribution (A) is the most cost- effective solution. It directly addresses the issue of broadcasting by ensuring the entire table is available on each node, significantly improving join performance without incurring substantial additional costs.
Topics
Community Discussion
No community discussion yet for this question.