SnowPro Core Certification — Question 644

A complex SQL query involving eight tables with joins is taking a while to execute. The Query Profile shows that all partitions are being scanned.

What is causing the query performance issue?

Answer options

• A. Pruning is not being performed efficiently.
• B. A huge volume of data is being fetched, with many joins applied.
• C. Incorrect joins are being used, leading to scanning and pulling too many records.
• D. The columns in the micro-partitions need granular ordering based on the dataset.

Correct answer: A

Explanation

The correct answer is A because inefficient pruning means that unnecessary data is being scanned, which slows down query performance. Options B and C may contribute to performance issues but do not directly address the partition scanning. Option D discusses ordering but does not relate to the core issue of pruning in this context.