Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 199

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

    Correct Answer: C

    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.

Discussion
tejarunOption: C

Average and Sum functions will need compute while min function can execute from cloud services layer

ntechkuma

Moderator should update correct answers. most of the questions have wrong answers.

SV1122

Was on exam Dec 31st 2022

SV1122Option: C

Min and Max values can be retrieved from micro-partitions metadata stored in the Cloud Services layer

Mallikharjuna452Option: C

C is correct answer

YoshiSamoZouOption: C

c correct

pranaligOption: C

Correct answer:C

PrashantGupta1616Option: C

answer is C ,min and max can execute from cloud service

_yyuktaOption: C

C. SELECT MIN(ORDER_AMT) FROM SALES;

Gaurangvp44Option: C

MIN Is t h e right

Marge23Option: C

MIN no need vw

singhksOption: C

C is the answer

bonniezlOption: C

C is correct

shyemkoOption: C

Below are what is collected in Metadata : - Range of values including Max, Min & Count - Number of distinct values -Other optimization metadata

Josa2Option: C

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.

KarBiswaOption: C

MIN , MAX is ideal for this case

thejebyOption: C

C is the answer