Snowflake Exam COF-R02 Topic 1 Question 24 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 24
Topic #: 1

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

ASELECT SUM (ORDER_AMT) FROM SALES;

BSELECT AVG(ORDER_QTY) FROM SALES;

CSELECT MIN(ORDER_AMT) FROM SALES;

DSELECT ORDER_AMT * ORDER_QTY FROM SALES;

Show Suggested Answer

Suggested Answer: A

by Bette at Jan 26, 2024, 09:11 AM

Limited Time Offer

25%

Off

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Renea

8 days ago

But for MIN function, it doesn't require any computation, so it can be completed without queries.

upvoted 0 times

...

Deeanna

10 days ago

I disagree, I believe the answer is A) SELECT SUM (ORDER_AMT) FROM SALES.

upvoted 0 times

...

Renea

12 days ago

I think the answer is C) SELECT MIN(ORDER_AMT) FROM SALES.

upvoted 0 times

...

Jin

14 days ago

But wouldn't calculating the minimum value also require computation?

upvoted 0 times

...

Leatha

17 days ago

I think the correct answer is C. Selecting the minimum order amount from the sales table doesn't require compute, as it's just retrieving the lowest value.

upvoted 0 times

...

Daron

18 days ago

I disagree, I believe the answer is C) SELECT MIN(ORDER_AMT) FROM SALES.

upvoted 0 times

...

Jin

23 days ago

I think the answer is A) SELECT SUM (ORDER_AMT) FROM SALES.

upvoted 0 times

...