Answer-first summary for fast verification
Answer: Change the distribution style of the store location table from EVEN distribution to ALL distribution.
Changing the distribution style to ALL places a complete copy of the table on every compute node. Because the store location table is constantly being broadcast (indicating it's likely smaller and frequently joined), ALL distribution removes the need to broadcast it during queries, significantly speeding up query performance in a cost-effective way compared to upgrading the node size.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 33 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?
A
Change the distribution style of the store location table from EVEN distribution to ALL distribution.
B
Change the distribution style of the store location table to KEY distribution based on the column that has the highest dimension.
C
Add a join column named store_id into the sort key for all the tables.
D
Upgrade the Redshift reserved node to a larger instance size in the same instance family.
No comments yet.