Snowflake
ADA-C01 · Question #38
ADA-C01 Question #38: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
Question
An Administrator is evaluating a complex query using the EXPLAIN command. The Globalstats operation indicates 500 partitionsAssigned. The Administrator then runs the query to completion and opens the Query Profile. They notice that the partitions scanned value is 429. Why might the actual partitions scanned be lower than the estimate from the EXPLAIN output?
Options
- AThe EXPLAIN results always include a 10-15% safety factor in order to provide conservative
- BThe GlobalStats partition assignment includes the micro-partitions that will be assigned for
- CRuntime optimizations such as join pruning can reduce the number of partitions and bytes
- DIn-flight data compression will result in fewer micro-partitions being scanned at the virtual
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.