Free Snowflake SnowPro-Core Actual Exam Questions - Question 14 Discussion

I’m thinking A could be tossed out since queries without filters or aggregation usually run fast anyway. D’s off because search optimization is a different feature altogether. Between B and C, query acceleration likely helps more with big scans and filtering rather than high cardinality groups. So I’d go with B here too.

It’s B, since acceleration speeds up queries needing big data scans with filters.

That makes sense, B fits because acceleration targets heavy scans with filters best, so B.

Option B makes sense since queries with large scans but selective filters still need to process a lot of data initially, so acceleration can help cut down that workload significantly.

D, since search optimization probably overlaps with acceleration, reducing extra benefit.

B imo – selective filters reduce data scanned, so acceleration cuts query time more.

It’s C because high cardinality in GROUP BY usually means lots of data to process, so query acceleration can really cut down the compute time. Queries without aggregation (A) wouldn’t gain much from acceleration.

Maybe C because high cardinality GROUP BYs can really slow things down, so acceleration might help speed those up by optimizing how the groupings are processed.

B seems right since large scans with selective filters can speed up a lot using query acceleration.