ExamGecko
Question list
Search
Search

Question 153 - COF-C02 discussion

Report
Export

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

A.
SELECT SUM (ORDER_AMT) FROM SALES;
Answers
A.
SELECT SUM (ORDER_AMT) FROM SALES;
B.
SELECT AVG(ORDER_QTY) FROM SALES;
Answers
B.
SELECT AVG(ORDER_QTY) FROM SALES;
C.
SELECT MIN(ORDER_AMT) FROM SALES;
Answers
C.
SELECT MIN(ORDER_AMT) FROM SALES;
D.
SELECT ORDER_AMT * ORDER_QTY FROM SALES;
Answers
D.
SELECT ORDER_AMT * ORDER_QTY FROM SALES;
Suggested answer: B

Explanation:

Operations that do not require compute resources are typically those that can leverage previously cached results. However, if no queries have been executed previously, all the given operations would require compute to execute.It's important to note that certain operations like DDL statements and queries that hit the result cache do not consume compute credits2.

asked 23/09/2024
Ruben Dallibor
32 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first