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:

Giffin Good

A type of good for which demand increases as the price increases, contradicting the basic law of demand due to the income effect.

Income Effect

The relationship between changing income levels in an economy or for individuals and the subsequent effect on goods and services demand.

Substitution Effect

Describes how consumers react to an increase in a good's price by substituting another good, affecting the quantity demanded.

Marginal Utility

The additional utility or enjoyment derived from the consumption of one more unit of a product or service.