QuestionQ25

VerifiedData Operations and Support

A company’s data engineer must optimize the performance of SQL queries against tables. The company stores its data in an Amazon Redshift cluster. Because of budget limitations, the data engineer cannot increase the cluster size.

The company stores data in multiple tables and loads it by using the EVEN distribution style. Some tables are hundreds of gigabytes in size. Other tables are smaller than 10 MB.

Which solution will satisfy these requirements?

Explanation

Amazon Redshift ALL distribution copies the complete table to every compute node, which can eliminate data redistribution for joins. It increases storage, loading, and update costs, so it is appropriate for small, slowly changing tables rather than large tables. Declared primary and foreign keys provide constraint metadata that the query optimizer can use. AWS: Distribution styles

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!