Snowflake
ADA-C01 · Question #68
ADA-C01 Question #68: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #68. The question stem and answer options stay visible for context.
Question
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?
Options
- AThe STORE_ID should be numeric.
- BThe table is not big enough to take advantage of the clustering key.
- CSales across stores are not uniformly distributed.
- DThe cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a
Unlock ADA-C01 to see the answer
You've previewed enough free ADA-C01 questions. Unlock ADA-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.