ExpertHard1 markMultiple Choice
AWS SAA-C03 · Question 48 · Domain 3.3: Database Performance
A data analytics team uses Amazon Redshift for complex queries. They have a large fact table and several small dimension tables. Queries joining these tables are running slowly because data is being broadcast across the network between compute nodes.<br/><br/>Which Redshift distribution style should a solutions architect apply to the small dimension tables to improve query performance?
A data analytics team uses Amazon Redshift for complex queries. They have a large fact table and several small dimension tables. Queries joining these tables are running slowly because data is being broadcast across the network between compute nodes.<br/><br/>Which Redshift distribution style should a solutions architect apply to the small dimension tables to improve query performance?
Answer options:
A.
EVEN distribution
B.
KEY distribution
C.
ALL distribution
D.
AUTO distribution
How to approach this question
Understand Redshift distribution styles and their use cases.
Full Answer
C.ALL distribution✓ Correct
ALL distribution
With ALL distribution, a copy of the entire table is distributed to every node. This is ideal for relatively slow-moving, small dimension tables because it ensures that the data required for a join is always available locally on the node, eliminating network broadcast traffic.
Common mistakes
Choosing KEY distribution for small tables, which doesn't fully eliminate network traffic if joining on different keys.
Practice the full AWS SAA-C03 Practice Exam 6
65 questions · hints · full answers · grading
More questions from this exam
Q01A company has multiple AWS accounts in an AWS Organizations organization. The security team wants...MediumQ02A company has two AWS accounts: Account A for development and Account B for production. Developer...MediumQ03A mobile application needs to authenticate users using their social media accounts (Facebook, Goo...EasyQ04A company is running an application on Amazon EC2 instances. The application needs to connect to ...MediumQ05A company has 50 AWS accounts managed by AWS Organizations. The IT team wants to implement a cent...Easy