Snowflake
COF-R02 · Question #224
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
The correct answer is B. SELECT AVG(ORDER_QTY) FROM SALES. See the full explanation below for the reasoning.
Question
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
Options
- 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;
How the community answered
(38 responses)- A8% (3)
- B76% (29)
- C13% (5)
- D3% (1)
Community Discussion
No community discussion yet for this question.