Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
D: SELECT ORDER_AMT * ORDER_QTY FROM SALES involves a simple operation of multiplying the values of two columns. This operation can be performed solely by scanning the data and does not require a Compute Engine.
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
tejarun
Highly Voted 2 years, 4 months agontechkuma
Highly Voted 2 years, 1 month agoVLMBL_94
7 months, 4 weeks agojhfather
Most Recent 1 month agovivekmani2021
8 months agoMallikharjuna452
8 months, 2 weeks agoYoshiSamoZou
9 months, 1 week agopranalig
9 months, 3 weeks agoPrashantGupta1616
10 months ago_yyukta
1 year, 1 month agoGaurangvp44
1 year, 5 months agoMarge23
1 year, 6 months agosinghks
1 year, 7 months agobonniezl
1 year, 10 months agoshyemko
2 years agoJosa2
2 years, 1 month agoKarBiswa
2 years, 1 month agothejeby
2 years, 1 month ago