SnowPro Core Certification — Question 1219

Which metrics in the QUERY_HISTORY Account _Usage View can be used to assess the pruning efficiency of a query? (Choose two.)

Answer options

• A. EXECUTION_TIME
• B. PARTITIONS_TOTAL
• C. COMPILATION_TIME
• D. TOTAL_ELAPSED_TIME
• E. PARTITIONS_SCANNED

Correct answer: B, E

Explanation

The correct answers, B (PARTITIONS_TOTAL) and E (PARTITIONS_SCANNED), provide insights into how many partitions were considered versus how many were actually scanned during the query execution. This information is vital for determining the effectiveness of the pruning process. The other options, while related to query performance, do not specifically measure pruning efficiency.