Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
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 'SELECT MIN(ORDER_AMT) FROM SALES;'. Calculating the minimum value does not necessarily require compute if the minimum value is already stored in the metadata. Metadata can contain precomputed statistics such as min and max values which can be retrieved without scanning the table's data, thus avoiding the need for compute resources. In contrast, operations like SUM, AVG, and multiplication require scanning all relevant rows and performing calculations.
Average and Sum functions will need compute while min function can execute from cloud services layer
Moderator should update correct answers. most of the questions have wrong answers.
Was on exam Dec 31st 2022
Min and Max values can be retrieved from micro-partitions metadata stored in the Cloud Services layer
C is the answer
MIN , MAX is ideal for this case
I believe it's C, since once the METADATA stores it, it will know what's the DETERMINISTIC value without having to perform any calculation as suggested by A and B or run over all micro-partitions as it would occur in D.
Below are what is collected in Metadata : - Range of values including Max, Min & Count - Number of distinct values -Other optimization metadata
C is correct
C is the answer
MIN no need vw
MIN Is t h e right
C. SELECT MIN(ORDER_AMT) FROM SALES;
answer is C ,min and max can execute from cloud service
Correct answer:C
c correct
C is correct answer