Question 1

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.

Which Redshift distribution style should a solutions architect apply to the small dimension tables to improve query performance?

Accepted Answer

Understand Redshift distribution styles and their use cases.

Question 2

What mistakes do candidates make on this AWS SAA-C03 question?

Accepted Answer

Choosing KEY distribution for small tables, which doesn't fully eliminate network traffic if joining on different keys.

How to approach this question

Full Answer

Common mistakes

Practice the full AWS SAA-C03 Practice Exam 6

More questions from this exam