Amazon Exam DAS-C01 Topic 5 Question 43 Discussion

Actual exam question for Amazon's DAS-C01 exam

Question #: 43
Topic #: 5

A human resources company maintains a 10-node Amazon Redshift cluster to run analytics queries on the company's dat

a. 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?

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 table

DAn EVEN distribution style for the product table and an KEY distribution style for the transactions table

Show Suggested Answer

Suggested Answer: B

by Salena at May 05, 2022, 09:59 PM

Limited Time Offer

25%

Off

Get Premium DAS-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!