A Human Resources Company Maintains a 10-Node Amazon Redshift Cluster

question 3

Multiple Choice

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?

• A) An EVEN distribution style for both tables
• B) A KEY distribution style for both tables
• C) An ALL distribution style for the product table and an EVEN distribution style for the transactions table
• D) An EVEN distribution style for the product table and an KEY distribution style for the transactions table

---

Definitions:

Confidence Interval

An assembly of numerical values, generated from sample data, aimed at including the unexposed value of a population parameter.

Variance

A statistical measure that represents the degree to which a set of numbers are spread out, calculated as the average of the squared differences from the Mean.

Sample Size

The number of observations or units that make up a statistical sample.

Genet

Edmond-Charles Genêt, a French diplomat who caused a controversy in 1793 by violating diplomatic protocol in the United States during the French Revolutionary Wars.