DAS-C01 · Question #123
A human resources company maintains a 10-node Amazon Redshift cluster to run analytics queries on the company's data. The Amazon Redshift cluster contains a product table and a transactions table, and
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #123. The question stem and answer options stay visible for context.
Question
A human resources company maintains a 10-node Amazon Redshift cluster to run analytics queries on the company's data. The Amazon Redshift cluster contains a product table and a transactions table, and both tables have a product_sku column. The tables are over 100 GB in size. The majority of queries run on both tables. Which distribution style should the company use for the two tables to achieve optimal query performance?
Options
- AAn EVEN distribution style for both tables
- BA KEY distribution style for both tables
- CAn ALL distribution style for the product table and an EVEN distribution style for the transactions
- DAn EVEN distribution style for the product table and an KEY distribution style for the transactions
Unlock DAS-C01 to see the answer
You've previewed enough free DAS-C01 questions. Unlock DAS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.