A retailer uses a TRANSACTIONS table (100M rows, 1.

Snowflake ADA-C01 Question Answer

A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar(50)). The vast majority of analyses on this table are

grouped by STORE_ID to look at store performance.

There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning,

with large amounts of bytes processed by even simple queries.

Why is this occurring?

The STORE_ID should be numeric.

The table is not big enough to take advantage of the clustering key.

Sales across stores are not uniformly distributed.

The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.