SnowPro Core Certification — Question 159

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

Answer options

• A. SELECT SUM (ORDER_AMT) FROM SALES;
• B. SELECT AVG(ORDER_QTY) FROM SALES;
• C. SELECT MIN(ORDER_AMT) FROM SALES;
• D. SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Correct answer: C

Explanation

The correct answer is C, as finding the minimum value can often be determined without requiring additional compute resources if no previous queries have been executed. Options A and B both involve aggregations that require computation of all values before returning a result, while D involves a calculation that also necessitates processing each row's values.